Running Cumulative

richardcranney · Jul 31st 2006

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

pangolin · Jul 31st 2006

Re: Running Cumulative

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

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

richardcranney · Aug 18th 2006

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

richardcranney · Aug 18th 2006

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

JimFuller1 · Aug 18th 2006

Re: Running Cumulative

See attachment. Is that the idea?

Jim

richardcranney · Aug 18th 2006

Re: Running Cumulative

That my friend, is perfect!

Running Cumulative

Participate now!

Share