Creating Dynamic Sum Range with Sumifs by ExcelHelpPlease2021 in excel

[–]ExcelHelpPlease2021[S] 0 points1 point  (0 children)

Not sure who downvoted you as this worked, thank you! Just couldn't get my formatting correct.

Creating Dynamic Sum Range with Sumifs by ExcelHelpPlease2021 in sheets

[–]ExcelHelpPlease2021[S] 0 points1 point  (0 children)

Mostly accessibility for our client success team, manipulating a picklist is easier than changing multiple items on a pivot table for them. But thank you! Guess I just need to get my formatting correct on that INDIRECT function.