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
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
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
Re: Running Cumulative
That my friend, is perfect!
Don’t have an account yet? Register yourself now and be a part of our community!