How to count the number of cells that are greater than the cell above each?

[DOS]

These cells are conditionally formatted to be red if the cell directly above is less than it and green if it's greater than. Each cell contains a simple function of SUM the row to the left plus the cell directly above it.

I'm pretty new to Excel so I've been testing functions out, and now I'm trying to count the number of cells that're greater than (or less than) the cell above each cell in this column.

I've tried combining COUNTIF and OFFSET, but I keep getting a return of 0 no matter what.

 

[Sulprobil]

=SUMPRODUCT(--(A1:A9<A2:A10))

 

[DOS]

=SUMPRODUCT(--(A1:A9<A2:A10))

Thank you!! Can you explain what exactly this is doing though?

 

[Sulprobil]

Hello,
You can evaluate any Excel function stepwise.
For example, in the formula editor select

A1:A9<A2:A10

and press F9. You will get a list of 9 boolean TRUE/FALSE values.
Now select this list together with the surrounding

--(...)

and press F9 again. You should get a list of 0/1 values which can finally be summed up by SUMPRODUCT.
Now try SUM instead of SUMPRODUCT.
Regards,
Bernd

 

[DOS]

Hello,
You can evaluate any Excel function stepwise.
For example, in the formula editor select

A1:A9<A2:A10

and press F9. You will get a list of 9 boolean TRUE/FALSE values.
Now select this list together with the surrounding

--(...)

and press F9 again. You should get a list of 0/1 values which can finally be summed up by SUMPRODUCT.
Now try SUM instead of SUMPRODUCT.
Regards,
Bernd

Ah, I'm on mobile, so I can't do that, thank you though.