COUNTIF function
 

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.

--
NitaMax

COUNTIF function
 

=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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"NitaMax" wrote:

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.

--
NitaMax

COUNTIF function
 

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

"NitaMax" wrote:

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.

--
NitaMax

COUNTIF function
 

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

Adjust your range to suit


"NitaMax" wrote:

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.

--
NitaMax