Still having problems with this formula

[numerion]

Ok, this is the formula I'm using but its not calculating the values for an individual cell in the C column. It takes the value in Column A and Column B and put the results in Column C for example C1 which if I only needed one row it would work fine. but when the formula is copied to severals cells in Column C example C1 thru C10, the values that are placed in column A and column B are added to the entire Column C not just an individual cell in Column C. If the value 1 is placed in Column A and B the result in Column C should be 2 which works fine for the first row but if the value 1 is placed in Column A2 and B2 the results in Column C1 and C2 is 4 not 2? So I don't think I'm using the right formula, if I'm wrong someone please help my understanding? Thanks

Numerion

C1=SUM(A:A)+SUM(B:B)

[MrShorty]

It seems so simple, that I feel like I must be missing something. If I understand what you want, shouldn't C1=A1+B1 work? When copied down, C2=A2+B2, C3=A3+B3, and so on. Is that what you want???

[Ron Coderre]

Hi, Numerion

Are you trying to get a running total to display in column C?
If yes, try putting this formula in C1 and copying it down:
=SUM($A$1:B1)

Ron