Calculating Percentiles for Subgroups

[Guest]

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

 

[Bernard Liengme]

=SUMPRODUCT( --($A$13:$A$6000=$A13), --($E$13:$E$6000>=750)
or
=SUMPRODUCT( --($A$13:$A$6000=$A13), --($E$13:$E$6000>=$B13)
see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Guest]

=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.