formula to make cumulative totals required

[calisto]

I have a long list of numbers and I want to make a cumulative running total
sounded pretty simple , but no

attached is a sample excel sheet showing how it should look

and another sample
I tried copy/paste the formula in J5 but it didn't work
then I tried to drag the formula in J5 to J6 etc but it only added the 2 totals-- not cumulative



could i have some help please

I've tried to attach an xls twice so far

[Glenn Kennedy]

One way:
=SUM($I$4:I4)

copied down

[calisto]

Glen, thanks for your simple & elegant solution --- solved that problem but I've
inadvertantly created another in the source data

I've reattached updated SAMPLE xlsm showing the actual numbers ( longitudes)
I need my ultimate result to be a daily cumulative total and as i'm not very conversant
with Excel, I split the problem into 2 pieces ( you don't have to split it ).
in ColH, I created a daily movement by making G5-G4 & where necessary, added 360 degrees for
consistency in daily movement -- that formula works fine.

your formula is intended to then add Col H6 to Col H5 to start the cumulative running total process.
your formula works perfectly on my whole number example but not on the real data, I think because
ColH includes a formula .

would it be possible for you to make it work please

thanking you
kevin

[Glenn Kennedy]

IF I4 will be blank:
=H5+I4

copied down.

IF I4 will contain text:
=H5+SUM(I4)

[calisto]

formula works fine -- all finished now
thanks for your help

[Glenn Kennedy]

Ytou're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.