Hi everyone,

I am looking for a way to count the last 10 items that are greather than and less than in a particular set of cells.

I am using the following formula for the less than and greather count.

=SUMPRODUCT(--(C13:C22>D13

:D22)) = formula in cell C2

=SUMPRODUCT(--(C13:C22<D13:D22)) = formula in cell D2

This gets the job done with some issues.

First, I have to manually change the cell ranges to match after data is added.

Second, any blanks in between may be omitted so that I do not get the full 10 count range I want.

Does anyone know of a way to do this without manually changing the cell ranges each time data is added.

P.S. I tried using INDIRECT("C" & B2) to use the value in cell B2 as the last cell number but I get an error when inserted in place of the static cell range used in the formula.

EE-CountLast10.xlsx