I use spreadsheets on a daily basis to organise and keep track of schedules/projects but adding sums and formulas are a total mystery to me.
Having a dilemma today...
Adding up multiple columns to display a total value in the final column is easy HOWEVER, I need to do the things like the following:
Year 1
100
Year 2
x
Year 3
x
What formula would I put into the year 2 cell to double the year 1 amount...
Following that, I'd like to drag the year 2 cell onto the year 3, year 4, year 5 cells to keep multiplying?
Such a simple task shouldn't be such a nightmare but my google skills are failing me with this one
Having a dilemma today...
Adding up multiple columns to display a total value in the final column is easy HOWEVER, I need to do the things like the following:
Year 1
100
Year 2
x
Year 3
x
What formula would I put into the year 2 cell to double the year 1 amount...
Following that, I'd like to drag the year 2 cell onto the year 3, year 4, year 5 cells to keep multiplying?
Such a simple task shouldn't be such a nightmare but my google skills are failing me with this one