COUNTIF(...)+COUNTIF(...)
Using COUNTIF() with OR condition
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
The COUNTIF() function measure OR condition by adding separate COUNTIF() formulas for each condition. Thus we get the final count for different criteria.