Home » Posts

Count if row meets internal criteria

To count rows in a table that meet internal, calculated criteria, without using a helper column, you can use the SUMPRODUCT function. In the example shown, the formula in cell G5 is: =SUMPRODUCT(--(C5:C15>D5:D15)) The result is 3, since there are three rows where Previous sales are greater than Current sales.

April 14, 2025 · 1 min · 61 words · Patrick Williams

Table of Contents

But what if we don’t want to (or can’t) add a helper column?

In that case, we can use the SUMPRODUCT function withBoolean logic.

SUMPRODUCT function

TheSUMPRODUCT functionis designed to work with arrays.

Excel formula: Count if row meets multiple criteria

It multiplies corresponding elements in two or more arrays and sums the resulting products.

This allows us to perform a comparison between current and previous sales directly inarray1.

Excel formula: Count rows with multiple OR criteria

Excel SUMPRODUCT function

SUMPRODUCT function#

SUMPRODUCT function