公式库

Excel Formula To Aggregate Sales By Status

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

快速答案

Aggregate sales by status.

统一公式

ExcelGoogle SheetsWPS
=SUMIFS(B:B, A:A, 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.