Calculating Percentiles for Subgroups

S

SteveC

This counts the number of instances of say "oranges" in column A.
COUNTIF($A$13:$A$6000,$A13)

How do I modify this to count the number of "oranges" in Column A that have
a value of 750 or more in Column E?

thanks very much for your help.

SteveC
 
S

SteveC

=SUMPRODUCT(--($A$13:$A$6000=A2321),--($E$13:$E$6000>750))

Ok, found it, thanks. wrong title too. Should have been titled countif
across multiple columns.
 
Top