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!!!!!
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!!!!!