Count (or sum) rows that match any value from a list — an OR condition.
Copy this formula
=SUM(COUNTIF(A:A, {"Open","Pending","Review"}))Passing an array constant to COUNTIF returns one count per value; SUM adds them into a single OR total. For summing, wrap SUMIF the same way: SUM(SUMIF(A:A, {"East","West"}, C:C)).
=SUM(SUMIF(Region, {"East","West"}, Sales))→9,300Total sales for East OR West.
COUNTIFS combines conditions with AND. For OR across values in one column, the array-constant + SUM approach is correct.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.