I have a table in excel 2010 and sum formula is not working for some rows. *My A1 B1 also pick the data from another formula. Please help.

okey

there are many ways 

*  click File menu> Options> select  "account  automatic"

*- anther way 

you can copy sheet  data and paste it in a new work book sheet 

and paste  formulas and values only by special paste 

then  write formulas from begin an \\d ensure you write the right columns 

for  sum column you can  use short cut 

alt + =

*****   every time  you write  formula make sure that is working correctly 

you can comment in my answer if not enough 

kindly attach you fiel ... regards 

First of all as per my understanding you are trying to put sum formula in Column C for all the values in A & B Right?

First:  Copy the formula in C1 and paste it all over the C Column.

Second: if its still giving the same problem then either there is no data in A2 & B2 onwards or there is some formula scatering

formula scatterting can only be solved by reawarding the values or links to A & B columns.

Hope it works for you

Type this formula manually =SUM(A1:B1) in C1

It seems that your sum farmula is working well because it is calculating things. if it shows only formula in cells instead of the resulted calculation then we can say that there are some kind of  cell formating issues which can be easily resolved by using the short key (ctrl + `) control + backquote(sign just below the ESC key)

But your problem is moving around the cells from where your cells A1,B1 or A2 and B2 are getting their data. you should attach the file if it is not much secure or at least attach its screenshots so that any of us can configure the actual issue and its possible solutions

Fill in the data on A1 :2  B1 :2  C1 : Create Formula =SUM(A1:B1)

Select  from A1 to C1 and Drag down to copy  same data   and formula .

make sure that the format of the cell is NOT (text)

If A2, B2 are  containing a respective data related to the following line of the source cells that A1, B1 receive the data ... then you equation will work .. OK ?  

but if those cells are empty then the result become zero

try it

good luck

if its a table, it should copy the corresponding correct formulas when you drag down at column C. Provided that you have type correctly the formulas at  C1. so try writing the formulas like this, this will ensure that datas to be summed up are fixed at columns A & B.

@ c1 '=sum($A1:$B1)'... then you can drag down at column C in order to copy the formulas.