Countif .. Help required..

[kundanlal]

Dear Sir,

Using something like at K5, =COUNTIFS($D$5:$D$35,$J5,$I$5:$I$35,">=&($G$5/ROUND((($E$5/12)*$E$2),2))100%",$C$5:$C$35,"BM")..

Please help me in this.. Attaching sample file with required output. (Basically, wanted to count all such records in range with another condition of role='BM' and achievement >100%, would like to extend the condition for achievment>=100% but less than 110% and so on.. Achievement forumla ($G$5/ROUND((($E$5/12)*$E$2),2))..

Thanks and Regards,

Kundanlal

 

[Luke M]

Looks like you just have a bad quotation mark placement (see bolded area). Try this correction:

=COUNTIFS($D$5:$D$35,$J5,$I$5:$I$35,">="&($G$5/ROUND((($E$5/12)*$E$2),2)),$C$5:$C$35,"BM")

 

[kundanlal]

Actually, this works for only if range is >= achievement of G5. But I would like to count all achievements which are less than 100%, between 100% and 110%, 110% and 125% and more than 125%.. i.e. as per tabel..

 

[Luke M]

See attached. I used some helper cells in row 2 so you don't have to have so many unique formulas. One formula for the "BM" section, one for the "RM" section.