SUMPRODUCT + COUNTIF (count matches from a list) Function in Excel: Syntax, Examples and Free Practice
SUMPRODUCT + COUNTIF (count matches from a list) is an Excel Math & Trig function. Counts how many cells in a range match ANY value from a separate list, all in one formula.
SUMPRODUCT + COUNTIF (count matches from a list) syntax
Arguments
range: Range to checklist_of_values: A list of values to match against
When to use SUMPRODUCT + COUNTIF (count matches from a list)
Counting how many orders belong to any of several VIP customer IDs at once.
Practice SUMPRODUCT + COUNTIF (count matches from a list) online, free
Open the live Excel-style spreadsheet and try SUMPRODUCT + COUNTIF (count matches from a list) yourself. No Excel install or sign-up needed to start.
Practice SUMPRODUCT + COUNTIF (count matches from a list) now →More Math & Trig functions
Frequently asked questions
What does the SUMPRODUCT + COUNTIF (count matches from a list) function do in Excel?
Counts how many cells in a range match ANY value from a separate list, all in one formula.
What is the syntax of SUMPRODUCT + COUNTIF (count matches from a list) in Excel?
The syntax is =SUMPRODUCT(COUNTIF(range, list_of_values)). range: Range to check; list_of_values: A list of values to match against.
Where can I practice SUMPRODUCT + COUNTIF (count matches from a list) online for free?
Open the free live spreadsheet on Cellgrids and try SUMPRODUCT + COUNTIF (count matches from a list) 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