Hi. I'm trying to find a function that can check an array of values to find the 1st -ve value.

I have 3 blocks of cells;

Block 1 - B11:U22

Block 2 - B27:U38

Block 3 - B43:K54

The cells contain decreasing values. The sequence goes down then along e.g. B11:B22, C11:C22 etc along to column U. Then B27 is the next after U22.

Is there a way that I can add a forumula to a new cell on the sheet that identifies the 1st -ve value in sequence, and then adds a value to it?

thanks

Tony