COUNTIF is an obsolete function inherited from LOTUS-123

What can be done with COUNTIF
Can be done more easily with SUMPRODUCT
What can't be done with COUNTIF
Can be done with SUMPRODUCT

Counting with Excel COUNTIF

With the COUNTIF function, you can count the number of different products based on a single criteria like date OR city OR salesperson... SUMPRODUCT is like Excel COUNTIF on steroids,