Counting based on multiple conditions including date range

M

mahoobley

I'm going to try to make this dilemma as simple to explain as possible
by using a method we can all relate to :)

Lets say I have the following table, with it being an extract from
list of what I drank at the pub on certain dates:


Code
-------------------

|------A------|------B------|
20-Oct-03 Beer
25-Oct-03 Orange
13-Nov-03 Beer
16-Nov-03 Beer
18-Nov-03 Whiskey
20-Nov-03 Beer
27-Nov-03 Gin
03-Dec-03 Beer
05-Dec-03 Lemonade
...

-------------------

Basically, I want a cell to then tell me how many times I had beer i
November

(note - obviously what i'm trying to do is a bit more serious than thi
and contains alot more data, but I thought this would be a good way t
explain!
 
Top