Running Cumulative

• Hello, wondered if anyone could help.

Im wanting to run a running cumulative which only sits next to the last total on a spreadsheet.

Ive added an example to see if my rubbish explanation can be explained further.

Thanks

Files

• Re: Running Cumulative

this is one approach...put this in Cell E18 and copy

=IF(ISNUMBER(D19),"",SUM(\$D\$18:D18))

• Re: Running Cumulative

Hi, sorry for the long delay, but i cant seem to get that working. All the cells in D have the formula to subtract cell A from cell B, so it has a 0, which means it always has a number in there.

Any other ideas? Thanks

• Re: Running Cumulative

Explaining a bit better.

All the cells in Cell C will have a value, whether this is 0 minutes or 1 minute to 23:59 hours.

The formula there counts the 0 minutes as being a number, so doesnt follow. Is there anyway of making it find a number > 1 minute? Thanks

• Re: Running Cumulative

See attachment. Is that the idea?

Jim

Files

• Re: Running Cumulative

That my friend, is perfect!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!