=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