Excel Newbie needs Formula for 3 Column addition & total.

**Xegony42** · 08-24-2012, 12:01 PM

We need an excel formula that will add A+C fill B and give A for next row and repeat a couple hundred times. We have all C values. Thank you so much in advance!!

A,B,C
785.5,805.0,19.5
805.0,825.1,20.1
825.1,832.9,7.8
A,B,12.4
A,B,24.4

**K m** · 08-24-2012, 12:08 PM

A,B,C
785.5,805.0,19.5
805.0,825.1,20.1
825.1,832.9,7.8
A,B,12.4
A,B,24.4

I think what you want is:

In cell B1 the formula is =A1+C1
In A2 the formula is =B1

Not sure what you want with this: A,B,12.4, A,B,24.4

**Xegony42** · 08-24-2012, 12:14 PM

"I think what you want is:

In cell B1 the formula is =A1+C1 Yes but how can you get that to repeat 300+ times without typing in =A1+C1; =A2+C2 infinite?
In A2 the formula is =B1 Yes however again how do you get that to infinite formula?

Not sure what you want with this: A,B,12.4, A,B,24.4 " These were just examples of continuation of colums

**K m** · 08-24-2012, 12:25 PM

- Put you mouse cursor on the cell containing the formula.
- Using the right mouse button select COPY.
- Move to the cell(s) where you want the formula repeated.
- Holding down the left mouse button, highlight the range of cells where you want the formula repeated
- Click on the right mouse button and select PASTE and hit ENTER