COUNTIFS with OR logic (multiple SUMs) Function in Excel: Syntax, Examples and Free Practice
COUNTIFS with OR logic (multiple SUMs) is an Excel Statistical function. COUNTIFS only supports AND logic natively — adding two COUNTIFS together is the standard workaround for an OR condition.
COUNTIFS with OR logic (multiple SUMs) syntax
Arguments
range: Range to check"Value A"/"Value B": Either value counts
When to use COUNTIFS with OR logic (multiple SUMs)
Counting orders that are either 'Shipped' OR 'Delivered' in one total.
Practice COUNTIFS with OR logic (multiple SUMs) online, free
Open the live Excel-style spreadsheet and try COUNTIFS with OR logic (multiple SUMs) yourself. No Excel install or sign-up needed to start.
Practice COUNTIFS with OR logic (multiple SUMs) now →More Statistical functions
Frequently asked questions
What does the COUNTIFS with OR logic (multiple SUMs) function do in Excel?
COUNTIFS only supports AND logic natively — adding two COUNTIFS together is the standard workaround for an OR condition.
What is the syntax of COUNTIFS with OR logic (multiple SUMs) in Excel?
The syntax is =COUNTIFS(range, "Value A") + COUNTIFS(range, "Value B"). range: Range to check; "Value A"/"Value B": Either value counts.
Where can I practice COUNTIFS with OR logic (multiple SUMs) online for free?
Open the free live spreadsheet on Cellgrids and try COUNTIFS 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 · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts