How do I set up a column

G

Guest

How do I set up a column to be the sum of previous item +2 cells and keep a
running total. Example Colums A B & C. A2+B2+C1=C2. Then A3+B3+C2=C3
 
G

Guest

I think you've already answered it, haven't you?

Enter the formula =A2+B2+C1 in to cell C2 and then drag it down the sheet.

Ian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from 205 columns to 1 column 4
how to use if formula in list (data validation list) 1
Linking cell ranges between rows and columns 1
Can a cell be turned on or off? 1
concatenate with arrays 4
multiplication of two array in a particular way 2
Turning rows of equal number of columns into 1 continuous row 1
compare cells, copy, loop 2

Top