Forum Discussion
I need to count how many times 2 different letters appear in a column & totals in diff. cells
Can you please upload (without any real names or other identifiable info) a copy of your spreadsheet.
It should be a fairly simple thing to summarize the data if what you keep has something like the following layout. A series of columns that could look like this (or some variation)
Date Agency AM/PM Count (that's four columns)
It could be more granular if you get reports that are more detailed. For example, if people are showing up for different purposes; if some of the people you're counting are volunteers, others are people being served...you might want to have different columns reflecting that
Summarizing data like this is one of Excel's strong suits...you just need to collect the data in an orderly (systematic) way.
I'm sure you'll find people here willing and eager to help. You can help us help you by giving a bit more details and, ideally, a sample of the workbook you've already created.
