COUNTIF or SUMIF Formula based on other column value needed urgently please?

[jamieswift1977]

Hi,

I have this formula to count persons under 18, which works fine: =COUNTIF($C$12:$C$65536,">"&(TODAY()-6574.35958))

However, I would like to use that exact same functionality (for the counted rows), but this time ONLY if cells ($E$12:$E$65536) = M

I have tried various combinations of formula's but I'm just not getting it - can anybody help please?

Many thanks in advance.

Jamie

[Fotis1991]

tRY USING sumproduct. Perhaps something like this.

=SUMPRODUCT(($C$12:$C$65536>(TODAY()-6574.35958))*($E$12:$E$65536="M"))

untested

[Kevin UK]

Hi
As you have Excel 2003 use the sumproduct function or for Excel 2007+ look into the countifs.

Please Login or Register  to view this content.

[jamieswift1977]

Perfect! Thanks so much for your speedy response and your valued help! Works great!

Incidentally, if anyone else needs this handy formula - I've also added the formula for Males (M) over 18 (or change it to match your own value).


Under 18
=SUMPRODUCT(($C$12:$C$65536>(TODAY()-6574.35958))*($E$12:$E$65536="M"))

Over 18
=SUMPRODUCT(($C$12:$C$65536<=(TODAY()-6574.35958))*($E$12:$E$65536="M"))


Thanks again! :o)

[jamieswift1977]

Thanks Kevin, Fotis' formula did just what I need. Thanks for your help anyway!

[Fotis1991]

.......................