View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scoob_a Scoob_a is offline
external usenet poster
 
Posts: 2
Default How do I count the times a number appears in a table using criteri

I'm getting really confused....

I need to count how many times a number appears if it has a specific word
written next to it....for example....

A B
1 1 Summer 1
2 2 Summer 2
3 1 Autumn 1
4 3 Autumn 2

I need to count how many times the number 1, 2 and 3 appear next to Autumn 2
in the table..... does that make any sense?
I've tried using the Dcount function and either I'm not doing it right, or
it doesn't work for this... The countif formula works if I don't need to
specify summer or autumn, but in this case I do...
Can anyone help?...Please? It's driving me nuts!
Thanks