Conditional Formula, counting one criteria in a range based on ano
 

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!

Conditional Formula, counting one criteria in a range based on ano
 

Hi,

Try this

=SUMPRODUCT((A1:A24="Male")*(B1:B24="British"))

Mike

"sarahlbdarling" wrote:

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!

Conditional Formula, counting one criteria in a range based on ano
 

For XL2007:

=COUNTIFS(A1:A100,"Male",B1:B100,"British")


"sarahlbdarling" wrote:

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!

Conditional Formula, counting one criteria in a range based on ano
 

Hi,

using reference cells:

=SUMPRODUCT(--(A1:A10=D1),--(B1:b10=D2))

Where D1 contains Male and D2 contains British.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sarahlbdarling" wrote:

I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to
work. I have tried many many variations of counta, countif, countifs, if etc
and none work.....where am I going wrong!