Calculate maximum value of series of cash flows

[Peter Carr]

I have a spreadsheet with a series of monthly cash flows (column C. I want to calculate the maximum balance of the running total of the cash flows.
I can do this by using a running total column using the MAX function, but my challenge is, can it be done without the running total column?.
In this example the answer I want is 243 (cell D10), but can this be done without column D, using olnly the numbers in column C. I imagine the answer involves array formulas?

 

[NARAYANK991]

Hi Peter ,

One way is :

=MAX(SUBTOTAL(9;(OFFSET(C$2;;;ROW(INDIRECT("1:" & ROWS(Table1[Cash Flow])));1))))

entered as an array formula , using CTRL SHIFT ENTER.

Narayan

 

[bobhc]

Upload of any use?