How do I use the Excel Formula To Calculate Total Revenue By Color formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Calculate Total Revenue By Color

Sum by by color with a ready-to-use formula for Excel, Google Sheets, and WPS. Excel/WPS needs a ColorIndex helper range built with GET.CELL; Google Sheets needs an Apps Script custom function.

Quick answer

Calculate Total revenue by color.

Unified formula

ExcelWPS

=SUMIF(ColorIndex, E2, B:B)

View platform differences

Google Sheets

=SUMBYCOLOR(B2:B200, E2)

How it works

Replace the sample range (like A2:A) with your real range.
Keep the same column order used in the example.
Fill down to apply the formula to every row.

Need a custom version?

Related formulas

Excel Formula To Sum By Color

Sum by color with a ready-to-use formula for Excel, Google Sheets, and WPS. Excel/WPS needs a ColorIndex helper range built with GET.CELL; Google Sheets needs an Apps Script custom function.

Excel Formula To Sum By Cell Color

Sum by cell color with a ready-to-use formula for Excel, Google Sheets, and WPS. Excel/WPS needs a ColorIndex helper range built with GET.CELL; Google Sheets needs an Apps Script custom function.

Excel Formula To Sum By Fill Color

Sum by fill color with a ready-to-use formula for Excel, Google Sheets, and WPS. Excel/WPS needs a ColorIndex helper range built with GET.CELL; Google Sheets needs an Apps Script custom function.

Excel Formula To Sum Sales By Status

Sum sales by status with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Sales By Color

Sum by by color with a ready-to-use formula for Excel, Google Sheets, and WPS. Excel/WPS needs a ColorIndex helper range built with GET.CELL; Google Sheets needs an Apps Script custom function.

Excel Formula To Sum Sales By Category

Sum sales by category with a ready-to-use formula for Excel, Google Sheets, and WPS.