I use the functions count and countif very frecuenly in my Excel sheets.
Few weeks ago, I needed to count the days of a array of dates and I couldn’t use other column to extract the day of this dates with the day() function.
For this reason I used the SUMPRODUCT funtion.
The SUMPRODUCT function description is: “Returns the sum of the products of corresponding ranges or arrays”, but SUMPRODUCT has more features.
One of this characteristics is count a range with a function inside the own function.
For Example: =SUMPRODUCT(–(DAY(D1:D10)=1))
This Example count all the days number “1” in the array D1:D10:
SUMPRODUCT is a very powerful function. You can read more information in:
Excel SUMPRODUCT Function
What is Excel SUMPRODUCT formula and how to use it? (In This post you can looking for the use of “–” simbol)