COUNTIF function

[Guest]

I have Gender, Age and City columns.
I need a COUNTIF formula that will enable me to count, for example:

- number of girls, aged 6
- number of girls, aged between 6 and 12, from London

The formula I used for the gender is =COUNTIF(D2482,"G").

So far, it is not going too well.

Any help would be grately appreciated.

 

[Guest]

=SUMPRODUCT(--(A1:A10=6),--(B1:B10="London")) where A1:A10 contain the girls'
age and B1:B10 contain their location.

COUNTIF works on only one condition, i.e., the count of girls.

Dave

 

[Guest]

Good News for you!! Excel 2007 ships with new series of functions ending with
'S' which support multiple functions!!

SUMIFS
COUNTIFS
and the like.

Be ware.. though many of the S functions are extensions of the regular
functions.. some like SUMIF have difference in order of arguments

 

[Guest]

=SUMPRODUCT(--(A1:A100>=6),--(A1:A100<=12),--(B1:B100="London"))

Adjust your range to suit