registration counts

[Scout ROB]

working on a sheet that is fairly complex, but I'm struggling with an issue with counting with multiple criteria.

for an specific event which is conducted in several locations, on different dates and want to count how many adults and youth are attending by the name of the group.

My raw data comes from an on-line program so I can't change that format. But this does download to excel with specific title names, Basically its a data dump, several other columns are purposely deleted.


event name, event date and Y/A? (Youth/Adult?)

I'm building a summary sheet (SHAED AREA), (THIS WILL FEEED INTO ANOTHER REPORT) that will take the criteria and count the number of either Y or A at the location and the date

I've HIDDEN COLUMNS, THESA ARE THE ONES I'M INTERSESTED IN.

 

[6StringJazzer]

You should use a pivot table for this.

 

[Scout ROB]

You should use a pivot table for this.

ya, I had thought about that. Problem is this worksheet will be duplicated for other events as well. and the column headings, thought will be spelled the same, the columns maybe different because of how they were originally set up. Also, trying to make it easy for the support staff person, who may not understand pivot tables and all they would need to do is paste the data into the same sheet to update our reports.