Hi,
I'm having difficulty with counting a number of values based on a range of dates. (See example spreadsheet attached)
In column A, I have opening dates for requests, e.g. 12-Jun-2009, in the 'Date' format.
In column B, I have categories for each request, (1, 2 or 3) ('General' format).
I want to count all the requests opened for each category in a given calendar month.
For example, count all the Category 1 requests opened in June 2009.
Using the Countif function, I can count the total number of requests (i.e. all categories) opened in June 2009, and I can also count all of the requests opened for a given category over the whole period.
However, I cannot find a way of combining the two conditions (although it is possibly a fairly simple solution).
Any advice appreciated!
Thanks,
Sean Donohoe.
Bookmarks