SUMIFS with OR logic (multiple SUMs) Function in Excel: Syntax, Examples and Free Practice
SUMIFS with OR logic (multiple SUMs) is an Excel Math & Trig function. SUMIFS only supports AND logic natively — adding two SUMIFS together is the standard workaround for an OR condition.
SUMIFS with OR logic (multiple SUMs) syntax
Arguments
sum_range: Range to sumrange: Range to check"Value A"/"Value B": Either value counts
When to use SUMIFS with OR logic (multiple SUMs)
Summing revenue from either the East OR West region as one combined total.
Practice SUMIFS with OR logic (multiple SUMs) online, free
Open the live Excel-style spreadsheet and try SUMIFS with OR logic (multiple SUMs) yourself. No Excel install or sign-up needed to start.
Practice SUMIFS with OR logic (multiple SUMs) now →More Math & Trig functions
Frequently asked questions
What does the SUMIFS with OR logic (multiple SUMs) function do in Excel?
SUMIFS only supports AND logic natively — adding two SUMIFS together is the standard workaround for an OR condition.
What is the syntax of SUMIFS with OR logic (multiple SUMs) in Excel?
The syntax is =SUMIFS(sum_range, range, "Value A") + SUMIFS(sum_range, range, "Value B"). sum_range: Range to sum; range: Range to check; "Value A"/"Value B": Either value counts.
Where can I practice SUMIFS with OR logic (multiple SUMs) online for free?
Open the free live spreadsheet on Cellgrids and try SUMIFS with OR logic (multiple SUMs) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts