Excel SUMPRODUCT Count Cells
The SUMPRODUCT function in Excel is a very versatile function that will give different results depending on the arguments entered.
Normally, what the SUMPRODUCT function does is multiply the elements of one or more arrays and then add or sum the products together.
But by adjusting the form of the arguments, SUMPRODUCT will count the number of cells in a given range containing data that meets specific criteria.
Since Excel 2007, the program also has the COUNTIF and COUNTIFS functions that will allow you to count cells that meet one or more set criteria.
The SUMPRODUCT function in Excel is a very versatile function that will give different results depending on the arguments entered.
Normally, what the SUMPRODUCT function does is multiply the elements of one or more arrays and then add or sum the products together.
But by adjusting the form of the arguments, SUMPRODUCT will count the number of cells in a given range containing data that meets specific criteria.
Since Excel 2007, the program also has the COUNTIF and COUNTIFS functions that will allow you to count cells that meet one or more set criteria.