View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NitaMax NitaMax is offline
external usenet poster
 
Posts: 9
Default COUNTIF formula in multiple columns

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