Hello!

I have a file that contains the product SKU, Vendor Name and then page view count for each SKU (along with a ton of other metadata). For example:

SKU Vendor Name Page Views
B001 Vendor A 0
B002 Vendor A 12
B003 Vendor A 3
B004 Vendor A 213
B005 Vendor A 24
B006 Vendor B 56
B007 Vendor B 245
B008 Vendor B 2456
B009 Vendor B 765
B010 Vendor C 23
B011 Vendor C 78
B012 Vendor C 34
B013 Vendor D 14
B014 Vendor D 47
B015 Vendor D 24
B016 Vendor D 462

I'd like to create a list that tells me who the top 20 vendors with the highest total sum of page views are. In the example above the result would be:

Vendor Name Sum of Page Views
Vendor B 3522
Vendor D 547
Vendor A 252
Vendor C 135

Normally I would just use a Pivot table for this and it's done, but the file is gigantic and regularly updated through an ETL data connection which can change the list of vendors and products every week - and Pivot tables just seem to crash Excel when I refresh the data. Is there a way to create the list using a blend of formulas instead?

Any help will be hugely appreciated, even if it's to confirm that Pivot tables are the only way! Thank you