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.
Quick answer
Unified formula
ExcelGoogle SheetsWPS
=SUMIFS(C:C, A:A, "NA", B:B, "Cancelled")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.