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 Sum Values By Region Anz And Status Pending

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

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

Sum values by region ANZ and status Pending.

ExcelGoogle SheetsWPS

=SUMIFS(C:C, A:A, "ANZ", B:B, "Pending")

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

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

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

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

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

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