hmmmm

Originally Posted by 00T

sorry but im bad at this, any help would be greatly appreciated.

i am try to add to user inputted values together to get a total, and that total will then be updated every time two new values are inputed.

i.e
day 1

cell a1= 20 ///input
a2= 15 ///input
a3= 35 ///total
a4= 35 ///year total
next day

a1= 2
a2= 20
a3 = 22
a4 = 57


thanks

Hi,

In A3 put =A1+A2 or =Sum(A1:A2)

in A4 put =A3+B3

where 0 is the rest of your years figure.

for the next day you will need to select A1:A3 and Insert, shift cells right,

however, this is not the usual method of working, after 256 days your sheet dies.

More common is:

A1="Date", B1 = "Amount", C1="Amount", D1="Total", E1="YTD"

in A2 put =Today()

then click the small square in the bottom right corner and drag that down a few rows, the date will increase daily.

Make your entries in B2,C2 (next day B3 & C3, then B4 & C4) etc

in D2 =Sum(B2:C2)
in E2 =Sum(Offset(E2,-1,0)+D2)

for D2 and E2 drag the fill-handle down to repeat the formula on each day as required.

Let me know how you go
---

Formulas fill is at http://www.mvps.org/dmcritchie/excel/fillhand.htm
---

Originally Posted by 00T

Thanks for the help.
However, i was hopeing to make it more userfriendly should i say.
I dont really want to have to make it for all 365 days.

My hope was to just be able to enter the numbers and be able to sum them up on a day to day basis without haveing all of that.

thanks anyways

unfortunately Excel doesn't (easily) work that way, it uses a reliable audit-trail method that shows the contents of each figure, rather than emulate a calculator.

This is possible, albeit unwise, with some VB Code, but I feel that is inappropriate for this purpose, any inaccuracies generated in the YTD would not be detectable.

You can follow as per your original display, each day copy the ytd figure, and Paste Special = Values to the B column (say B3) and use that cell reference in the ytd as =A3+B3

hth
---

Attachment 6907

I would recommend following Bryan Hessey's advice but I think this is what you are asking for

It would be difficult to work with as you added other information