Normally, SUMIFS is used with data in a vertical arrangement, but it can also be used in cases where data is arranged horizontally. The trick is to make sure the sum_range and criteria_range are the same dimensions. In the example shown, the formula in cell I5, copied down the column is:
Notice the criteria_range, B4:G4 is locked as an absolute reference to prevent changes as the formula is copied.
Totals for each color
By carefully using a combination of absolute and mixed references, you can calculate totals for each color in a summary table. Notice in the example below, we are now picking up the cell references, I4, J4, and K4 to use directly as criteria:
The formula below in cell I5, copied down and across the table is:
Notice references are set up carefully so that the formula can be copied across and down: