View Single Post
  #1   Report Post  
ITexcelNY ITexcelNY is offline
Junior Member
 
Posts: 1
Default 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!!