Count the no. of cells in a row greater than previous row

[vikas.trades25]

Hi,
I have a few columns.
Now I want to compute the share of cells in a row, which were greater than their corresponding values in previous row.
Also there are certain blank cells in certain columns, whose values start after some date.

I need to compute the values in Column I using a formula

How to do this.

Thanks

[tim201110]

=sumproduct(isnumber(b3:h3)*(b4:h4>b3:h3))/counta(b3:h3)

[vikas.trades25]

=sumproduct(isnumber(b3:h3)*(b4:h4>b3:h3))/counta(b3:h3)

Thanks for sending this.
Can you tell me, what if I want to ensure the current row also does not include blanks in the computation

[GeoffW283]

I created a new test case to exercise your new requirement of blanks in the current row that are not present in the previous row:
share.png

What result do you expect in this case? (3/7)*100 ?
If so then Tim's formula works as is.

Or do you expect (3/5)*100 ?
If so then the following mod to Tim's formula should work. In J4 copied down:

Please Login or Register  to view this content.