How to create an overview of the sum of rows per record in a large dataset

[marcvanderpeet12]

Dear all,

I have a dataset that looks like the tab: data (I now provided 34 rows of data but the actual dataset is a lot bigger). From this dataset, I would like to create an overview like example_output.

I tried to accomplish this via database sum formulas. The problem however though is that I have >1000 agents and prefer not to make >1000 database formulas. Does anybody have another way to achieve my end result?

 

[AlanSidman]

You will need to explain the correlation between the two sheets. They do no appear to line up and you have not provided any headings for the output sheet. More info please

 

[Peter Bartholomew]

Assuming your columns of numbers on the output sheet correspond to the columns on the data sheet, either COUNTIFS or SUMIFS should provide the correct results
= COUNTIFS(Table1[agent], Name, Table1[queryTag_test_compliance_query], 1)

[I have converted your data to a table because I never use spreadsheet cell references except for ad-hoc calcs that I delete after use]

 

[p45cal]

…or a straightforward pivot table at H1 of the example_output sheet.

 

[marcvanderpeet12]

…or a straightforward pivot table at H1 of the example_output sheet.

Awesome, this is exactly what I am looking for. Thanks!