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
Bookmarks