Sum of the greatest run of negitive numbers
Hi, Not sure if this is what you have tried:
1: Assuming each run is on a different column
Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..
Then you can use:
=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).
If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)
How to use the excel countif formula
×