Sumifs within Offset Match
Hi I need help!
I'm trying to create a sum formula using offset matches.
Essentially, I want avoid using sumifs since the columns could change order, but the headers will not change.
This data will feed into a template.
Example:
Category is column A, Sales is B, Cost is C and Units is C.
CATEGORY SALES COST UNITS
B
E
R
B
E
R
Category repeats throughout the data, but I might add additional metrics to the template and don't want to have to change the range of the sumif each time I modify the data or the report and would prefer to have the sum combined with a match formula.
Any help would be appreciated!
Let me know if clarification is needed.
Thanks!!
|