COUNTIF function

N

NitaMax

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(D2:D482,"G").

So far, it is not going too well.

Any help would be grately appreciated.
 
D

Dave F

=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
 
C

Chinni Krishna Reddy

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
 
T

Teethless mama

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

Adjust your range to suit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top