phillygirl777
Member
Greetings,
I am trying to create a unified formula that can be copied without modifications to multiple tabs (this example is obviously simplified).
On the attached spreadsheet, I populated the tab labeled "North" with the shell for the desired outcome. I want to do the SUMIFS by using the division name and the product type. I know I can modify the column number for each tab and just use a simple SUMIF with Data!$C:$C being the SUMRANGE and DATA!$B:$B being the criteria range (equal to $B$1 and $C$1).
I was wondering if there is a way to do so without writing a macro. I am thinking about using the MATCH function to identify the column as =MATCH($A$1,Data!$C$1:$F$1,0), but seem to be stuck as to what formula to embed it into.
Thank you!
I am trying to create a unified formula that can be copied without modifications to multiple tabs (this example is obviously simplified).
On the attached spreadsheet, I populated the tab labeled "North" with the shell for the desired outcome. I want to do the SUMIFS by using the division name and the product type. I know I can modify the column number for each tab and just use a simple SUMIF with Data!$C:$C being the SUMRANGE and DATA!$B:$B being the criteria range (equal to $B$1 and $C$1).
I was wondering if there is a way to do so without writing a macro. I am thinking about using the MATCH function to identify the column as =MATCH($A$1,Data!$C$1:$F$1,0), but seem to be stuck as to what formula to embed it into.
Thank you!