Setting multiple conditions to return a figure from multiple cells
In C3 enter the formula (after changing 100 to your last row)
=SUMPRODUCT(--(A1:A100="Female"),--(B1:B1000))
or
=SUMPRODUCT(--(A1:A100=A3),--(B1:B1000))
If you want to copy this down to other cells then change A to $A
"Sapper" wrote:
Hi,
A B
1 Male
2 Male 21/06/71
3 Female 08/11/68 #
4 Male 11/04/70
5 Female
6 Female 19/10/69 #
I want to count the number of females in A with a date against their name in
B and return as a number.
=Countif(A1:A6,"Female") returns 3. How can I tell excel to look at those 3
cells(without knowing their references) and count those with a date in the
adjacent cell ie 2?
Thank you
|