I did a cut and paste. When doing the total for boys and girls I still end
up with a total greater than I expect.
--
NitaMax


"Wondering" wrote:

I tried the formula. It is giving me the correct answer. Are you sure you
entered it properly?

"NitaMax" wrote in message
...
It is coming up with a total greater than the number of people I have.
--
NitaMax


"Ron Coderre" wrote:

Try this:
=SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=5),--($F$3:$F$986<=12),--($H$3:$H$986="London"))

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"NitaMax" wrote in message
...
I am using the following formulat to get the number of Boys from London
between the ages of 5 and 12.

=SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London"))

I must have done something wrong because I am not getting anything that
makes sense.

Can someone help please?

Thank you
--
NitaMax