I want the boys from London aged between 5 and 12.

I tried and failed so far.
--
NitaMax


"Dave F" wrote:

Well, for one thing, this portion makes no sense: --($F$3:$F$986=512)

Those values that are equal to 5 are by definition not greater than
12. What are you trying to do with that?

Dave

On Oct 2, 3:15 pm, NitaMax wrote:
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