Forum Discussion
Return Date based on a sum of the total so far
Is there a formula that I could use that would return the date from a dataset based on a total so far for other conditions. A bit like a lookup but takes the sum so far into account. That's proba...
I think adding two helper rows with the cumulative sum of dry and rainy days is MUCH easier than trying to create a complicated single formula.