公式库

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.

快速答案

Calculate Total revenue by color.

统一公式

ExcelWPS
=SUMIF(ColorIndex, E2, B:B)
查看平台差异

Google Sheets

=SUMBYCOLOR(B2:B200, E2)

使用说明

需要定制版本？

相关公式

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.