I have a spreadsheet where new requests are recorded.

These requests contain a specific type of object (lets say a choice between 7 types of Jam) and the date the request was received.

On a seperate tab I have created a COUNTIF command to total requests for each month. So on the new tab I have a list of months a figure saying how many requests received in that month.

What I would like to try and do is break it down further to type total each month in the next columns.

e.g. For Sep-11 Total requests = 6. 2 strawberry, 2 apricot, 2 raspberry.

I cant work out how to do this as the range of the query is over the whole spreadsheet and not row specific.

Thanks

C