Excel Hopeful
Board Regular
- Joined
- Mar 13, 2006
- Messages
- 100
I have sheet with data. I want to count from 2 sets of criteria. Here is the example of the data:
1 a
1 z
1 a
1 z
2 a
2 z
2 z
3 a
3 z
3 z
I want a formula that counds how many A's the 1's have. It should come out as 2. Here are the formulas i've tried:
'=SUMPRODUCT(Sheet1!D2:D5715=A4,Sheet1!H:H=E4)
=count(if(sheet1!d:d=a4,If(sheet1!h:h=e5)))
1 a
1 z
1 a
1 z
2 a
2 z
2 z
3 a
3 z
3 z
I want a formula that counds how many A's the 1's have. It should come out as 2. Here are the formulas i've tried:
'=SUMPRODUCT(Sheet1!D2:D5715=A4,Sheet1!H:H=E4)
=count(if(sheet1!d:d=a4,If(sheet1!h:h=e5)))