How to sum the number in excel using formula
it is a very simple question if anybody had a idea about the excel formulas please share your ideas with me.开发者_如何学C I had a Excel Sheet I wants to add the 10 numbers for this i just use the formula =sum(A1:A10) in the cell A11 so cell A11 had the Total of 10 numbers my issue i wants to add the 10 numbers starts from A1:A10 the Total number must be displayed in A10 cell itself if i use the formula in the cell A10 = sum(A1:A10) it does not work thanks in advance for your time
That doesn't make sense, you would get into infinite recursion.
Say you got 1 in each of the fields, then A10 would end up being 10, but then A10 was changed so it would end up being 19 and then it was changed again etc etc
@Krusaint - Actually, I think the contents of A10 should be "=sum(A5:A9)" (without the quotes)
Delete value in cell A10. Put "=sum(A6:A9)" without quotes in A10.
If for example, the original value in A10 was 97, then do this:
=SUM(A5:A9)+97
精彩评论