Multiple sorts/countifs of different columns
Hello - new user here!
I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'metadata-type' fields. I'm struggling to create summary reports of those 'metadata-type fields' as I know there will be future values/names that are not entered yet, but I know that I will want to be able to summarize on them.
Examples of summary reports would be number of entries by category, for a given creator or department:
Name Cat1 Cat2 Cat3 TTL
Alex 15 4 8 27
Dept1 70 55 45 170
I understand how to countif and match and contains, but can I automatically create a summary that grows for each discrete value in either name or department (I'm AOK is they are different reports)?? I would expect this report to grow to 10000s of rows and cannot be filtering and recreating reports all the time. The goal would be to have all this update on our executive dashboard.
Thanks - Ben