| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating a YTD figures from changing monthly figure.
I have a column of figures in Row A (Monthly figs). I want to be able to
change these monthly figures and for it to be added to a running total in Column B (YTD). However each time I put the formula in =(a1+b1) and =(a2+b2) etc., the figures change all down column B whereas I only want the figs in the corresponding cell in Column B to change. How do I stop this happening? -- rGrant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating monthly budget expenses | Excel Worksheet Functions | |||
| Changing positive figures to minus figures | Excel Worksheet Functions | |||
| calculating in a changing range | Excel Discussion (Misc queries) | |||
| Formula to figure credit card payments | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Threaded Mode
