View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NitaMax NitaMax is offline
external usenet poster
 
Posts: 9
Default 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