Countif with multiple criteria

R

Romi

I have a table that looks like this.
R` Day 1 Day 2 .... Day 31
01 A1 A2 A11
02 A2 A1 A1
01 A1 A1 A11

On another sheet I have anoother table that looks like this.
R` Day 1 Day 2 .... Day 31
01 5 10 5
02 4 5 6

The second table needs to count the number of occurances from table 1 for
each R value that equals 6 out of a possible 10 entries. So there are about
12 R values in around 250 entries and a possible 10 A values for each day
1-31.

I've tried a pivot table and count if but I just can't ssem to get it right.

Using countif it should say somethine like
=Countif(A2,="01) and(or(B2:B250, = "A1"),(B2:B250,="A3"),(B2:B250,="A4")....

HELP!!!!!
 

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

Top