Calculations by columns

**dunn1423** · 10-20-2009, 08:33 PM

Hello All,

I would like to know the calculator formula for addition via columns.

Eg 1. If i were to place 135 into Column A ;
12.95 into Column C ;
i would need to yield a result of 147.95

Eg 2. Place 189 into Column A ;
12.95 into Column C
i would need to yield result of 201.95 and so on

in the attachment is the sample file.

Thanks
Dunn

**NBVC** · 10-20-2009, 08:41 PM

Try:

=A2+C2

copied down

**shg** · 10-20-2009, 08:41 PM

Enter this in E2: =A2+C2

Then select E2, put the cursor over the little square at the bottom right of the selection marquee (the cursor will change to a cross), left click, and drag down.