Can someone please help me create an Excel formula? Here is what the table looks like.
What I need is to sum up all cols that are after Jan and have model number 1.
Can someone please help me create an Excel formula? Here is what the table looks like.
What I need is to sum up all cols that are after Jan and have model number 1.
I would like to suggest two different methods,
Get Column total except Jan for Model 1.
Get total of all Columns except Jan for Model 1.
D209
to get Column total:=SUMIFS(D$206:D$208,$B$206:$B$208,1)
Fill formula Right.
F211
to get total of all
Columns:=SUMPRODUCT(($D$206:$F$208)*($B$206:$B$208=1))
Adjust cell references in the Formula as needed.