Subtotal by colors in Excel
In Excel, we can use the SUMIF function to perform subtotal by color.
How to find subtotal by color in Excel?
As shown in the screenshot below, to get the subtotal by the specified color Blue and White, the SUMIF function can help you easily.
How to use this formula?
1. Select a cell that is adjacent to the criteria value. In this case, I select cell H4.
2. Copy or enter the below formula into it and press Enter to get the result. Select the result cell, drag its AutoFill Handle down to get the subtotal for other colors.
Note: The two ranges ($D$3:$D$8 and $E$3:$E$8) in the formula are absolute references that won’t change when the formula is copied down.