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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding columns in pivot tables 4
Drop Downs, Index Match or what? 56
Counting multiple occcurrences between date range 3
Multiple If statements, Calculating quarterly % holding costs 0
Trying to count based on multiple criteria & cell comparisons 4
Make a mekko chart in Excel 2007 in three easy Steps 1
If with countif or counta 3
If and Countif 2

Top