Sumproduct

Sumproduct SUMPRODUCT COUNTIF
SUMPRODUCT COUNTIF
Count cells equal to one of many things Generic formula. =SUMPRODUCT(COUNTIF(rng,things)) Summary. To count the number of cells equal to one of many v...