I need to count how many times 2 different letters appear in a column & totals in diff. cells

lageared 

I'm actually not expecting you to understand all that I've done here. But yes, to your question, the list will just keep going. That's the thing about a database. And NO, you won't need to add a new sheet for a new month. That's another thing about a database. The reporting can be tailored to whatever timeframe you wish.

So I've been playing around a bit myself as you'll see on the attached. I've gone away from the Pivot Table to the newest technology that Microsoft has introduced just in the last year...ARRAY formulas. Just been learning them over the last week or two.

I added a column here to make it easier to select a week--this column determines a week number (e.g. the 14th week of the year)--and does it automatically based on the date you enter. Then to create a report, you just enter the start date of the week (I'm assuming Sundays for that)....and it automatically adjusts for that week.

And as you add rows to the database....it captures them and reports them for the corresponding week.

Now: I can help you create a drop down list of names for each center and then, for each center, a specific list of names of the people who are deployed in that center. You could update it from there, so it always was current.

Why don't you email me a list of the actual names of your Agencies....I'll create dummy lists for you to complete of the actual names of the real people....

As for the quarantine cases, it probably makes sense to track those on a separate sheet. It could be part of the same workbook, just so all of your records are in the same place.

And you'll be off and running for the next week and the rest of the year.