Explanation
First, a little context.
That’s exactly what the formula on this page does.
Then we use adouble negative(–) to coerce TRUE to 1 and FALSE to zero.
SUMPRODUCT function
TheSUMPRODUCT functionis designed to multiply and then sum multiple arrays.
TheCOUNTIF function, given the named rangeexcludewill return three counts, one for each item in the list.
SUMPRODUCT adds up the total, and this number is subtracted from the count of all non-empty cells.
The final result is the number of cells that do not equal values inexclude.
Literal contains key in logic
The formula on this page counts with “equals to” logic.
MATCH supports approximate and exact matching, andwildcards(* ?)
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
COUNTA does not count empty cells.
COUNTIF can be used to count…
