Questions

# Counting cells in Excel using multiple criteria, include date ranges

Locked

### Counting cells in Excel using multiple criteria, include date ranges

I have a spreadsheet that tracks numbers of participants in a program in each California county each month, over a 1 year period, arranged by date. I need to count how many would be from each county each month. For example, in a 12-month period, there may be 50,000 participants. An annual count of 1200 might be from one county, and of those 1200, 110 might be in January, 85 in February, etc. A different county might have only 65 for the year, with 4 one month, 6 another month. I need to break out the counts, by month, by county. I can send the spreadsheet in order to give a visual.

### Sort by one, subtotal break on the other, maybe totals-only

Just create a report, sort on one field, put in a subtotal break (group) on the other, and run it.

You may want two reports, one sorted by county then date; the other sorted by date then county.

### Thanks for the suggestion.

Thanks for your time. I'll give it a try, but here's the answer I needed:
=COUNTIFS(RANGE1,"alameda",RANGE2,">=7/1/2010",RANGE2,"<8/1/2010")