counting

[henrysacco]

Excel newbie here. I'm trying to count the number of cell that are greater than 90%, but i'd like to combine that with another query. I'd only like to count cells greater than 90% where D9:D119 have the text "New" in it.

Any help would be appreciated,

Thanks!

=COUNTIF(R9:R119,"<90%")

 

[njimack]

=SUMPRODUCT(--(D9:D119="New"),--(R9:F119>90%))

 

[Andrew Poulsom]

Try:

=SUMPRODUCT(--(D9:D119="New"),--(R9:R119<90%)) <!-- / message -->

 

[henrysacco]

Thank you both!