公式库

Excel Formula To Sum Values By Region Jp And Status Pending

Sum values for region JP and status Pending with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Sum values by region JP and status Pending.

统一公式

ExcelGoogle SheetsWPS
=SUMIFS(C:C, A:A, "JP", B:B, "Pending")

使用说明

需要定制版本？

相关公式

Excel Formula To Sum Values By Region Na And Status Paid

Sum values for region NA and status Paid with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values By Region Na And Status Pending

Sum values for region NA and status Pending with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values By Region Na And Status Cancelled

Sum values for region NA and status Cancelled with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values By Region Na And Status Refunded

Sum values for region NA and status Refunded with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values By Region Na And Status Active

Sum values for region NA and status Active with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Sum Values By Region Na And Status On Hold

Sum values for region NA and status On Hold with a ready-to-use formula for Excel, Google Sheets, and WPS.