Count Cells Between Two Values with SUMPRODUCT

Count Cells Between Two Values
© Ted French

SUMPRODUCT is not as well-known as some of Excel's other conditional functions such as the SUMIF or COUNTIF functions but that doesn't make it any less useful.

This usefulness stems, in part, from the variety of ways SUMPRODUCT can be used and the information that it can find.

One such use is to count the number of cells containing data that meets multiple criteria set by the user.

In the tutorial example the conditions are set as high and low values and SUMPRODUCT counts up how many cells contain numbers that fall between these two values.

For more information read this short tutorial on how to Count Cells Between Two Values with SUMPRODUCT.

Related Tutorials

• Sum Cells Between Two Values with SUMPRODUCT
• Use SUMPRODUCT to Calculate the Weighted Average
• Excel's SUMIFS Function