Counting based on multiple criteria

C

cathcarr

The data in my sheet is set out as follows:

ColumnA ColumnB
Group1 10
Group1 60
Group2 90
Group2 70
Group1 90
Group2 10
Group1 20

I am trying to count the amount of rows where Column A = Group1 and th
value in Column B is between 60 and 90. So the result of the formul
for this data would be 2.
I have tried various different combinations of the COUNTIF formula, bu
don't seem to be able to get it to work.
Any ideas???

Many thanks!
Cat
 
D

Domenic

Hi Cath,

Try,

=SUMPRODUCT((A1:A7="Group1")*(B1:B7>=60)*(B1:B7<=90))

Hope this helps
 
Top