Question

Locked

Counting cells in Excel using multiple criteria, include date ranges

By boboates ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

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

by oldbaritone In reply to Counting cells in Excel u ...

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.

Collapse -

Thanks for the suggestion.

by boboates In reply to Sort by one, subtotal bre ...

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")

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums