I want to count the consecutive positive and negative numbers in a column.
My issue is that I want that in a filtered sheet and also with text ("") below the numbers I want to count in.
Column A has the original data in let’s say sheet1. Then I copy the data into sheet2 like I do in column C.
With the helper column E I can get it to count the pos and neg incidents, but with #VALUE! because if the way I am doing it in column C.
After that the real result in column H cannot calculate the result and also returns #value
Any idea what should be different?
I think this is also not the right way to do it for a filtered sheet, right?
I want the result to be updated if the sheet is filtered and eg. only rows 2-11 are displayed.
Thank you very much in advance for your help!
consecutive_pos_neg.ods (113.2 KB)