Counting unique values with multiple conditions and criteria

[MagsinoAS]

Hi...I need help on how to accomplish this problem. The array formula
SUM(IF(FREQUENCY(IF(D14:D26 >= 90,MATCH(C14:C26,C14:C26,0)),ROW(C14:C26)-ROW(C15)+1),1)) only works for 1 condition but for multiple conditions like if the Training Index is <=89.99 and >=80, it doesn't work.

In my second problem, I may need to count the total unique teachers based on Quarters and the Training index conditions.

Appreciate any help.

Thanks.

 

[Rijnsent]

Hi MagsinoAS,
I've checked this forum and found this post: http://www.mrexcel.com/forum/excel-...nly-want-count-unique-values.html#post3097931 -> it seems like more conditions can be added to the formula, but haven't tried it myself. If it doesn't work, give a shout and I'll give it a spin.
Cheers,
Koen

 

[MagsinoAS]

That seems to work. I just added multiple IFs.

Thank you so much.