You need to use the SUMPRODUCT function.

=SUMPRODUCT((A1:A10="girl"),(B1:B10=6))

=SUMPRODUCT((A1:A10="girl),(B1:B10=6),(C1:C10="Lon don"))

Dave

--
Brevity is the soul of wit.


"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 6 and from London

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

So far, my efforts to adapt this have been fruitless.

Any help would be grately appreciated.

--
NitaMax