Frequencies using sumproduct function

[gary965]

Hi,

I have 2 columns:

Cro 87
Cro 24
Cro 89
Cro 7

I need to calculate the frequency of certain criteria such as the number of instances of Cro >84. To do this I have used

{ =SUMPRODUCT(($BD20021:$BD20028="Cro")*($BE20021:$BE20028>84))}

However I also need to find other frequencies such as Cro between 21 and 84any ideas.

Thanks

Gary

[rylo]

Gary

try

=SUMPRODUCT(($BD20021:$BD20028="Cro")*($BE20021:$B E20028>=21)*($BE20021:$B E20028<=84))


rylo

[VBA Noob]

Try

=SUMPRODUCT(--(A1:A4="Cro")*(B1:B4<=84)*(B1:B4>=21))+SUMPRODUCT(--(A1:A4="Cro")*(B1:B4>84))

VBA Noob