I know this has been asked before, but it is not working for me!
I have Microsoft 2003, it should be new enough.
I've followed all of the instructions in Help and other online guides and after I enter the formula and hit enter, only the formula itself remains in the cell. Or it does not add the whole range that I requested to be added.
Frustrating!
2007-03-25 21:00:58 · 4 answers · asked by Bird Brain 1 in Computers & Internet ➔ Programming & Design
"=sum(A1:A50)"
if you put this in A51, it will add everything from A1 to A50. If it still doesn't work, put the cursor on A51, Edit, Clear, All, and try again.
2007-03-26 04:58:15 · answer #1 · answered by ecoandy 2 · 0⤊ 0⤋
A B SUM
5 7 =a1+b1(enter)
9 3
2007-03-25 21:41:21 · answer #2 · answered by Ran 4 · 0⤊ 0⤋
I'll bet you forgot to put the "=" sign in front of the formula and Excel thinks it is just some text.
2007-03-25 21:09:04 · answer #3 · answered by ZORCH 6 · 0⤊ 0⤋
Either you are asking a complicated question that requires advance answers. eg copy/pastespecial/values/add option or
you are asking a basic question. In that case, ask your 10 year old nephew who work on excel before and show you how to do =sum(..)
2007-03-26 18:33:16 · answer #4 · answered by unnga 6 · 0⤊ 0⤋