I Need to Understand Running Total Sum Formulas. I'm using Excel 2010. and I'm typing in the basic correct formula to arrive at a running total for each ajacent cell to the left of it.
I put in the correct formula in Cell (B1) of Sum=(A1)
I then put in the correct formula in Cell (B2) Sum=(A1:A2) I then highlight the A1 part of the formula with an F4 Key to lock it in.
I then drag the B2 Cell all the way down the excel page to capture all of my running total coming from the (A) Column just to the left of my formula.
I've been doing this many times and the funning thing is I get the exact correct answers I'm looking for and I'm very happy. However. my question is one of learning and curiosity.
Why even though I'm getting the answers I want in the running total does it put an error message in each of the correct answers in each of the cells in the (B) column where I put my formulas.
I tryed to delete the error message spot but I don't know how to delete all of the error spots without going into each cell one by one.
So my question is what am I doing wrong in my formula that's giving me the correct answers but yet Excel is still telling me I have an error?
and how can I get rid of all the error message out of each cell without having to click on each cell one by one to do it when I might have over 500 or more cells to click on.
Thanks for any help you can give me on this one.
Zotah
I put in the correct formula in Cell (B1) of Sum=(A1)
I then put in the correct formula in Cell (B2) Sum=(A1:A2) I then highlight the A1 part of the formula with an F4 Key to lock it in.
I then drag the B2 Cell all the way down the excel page to capture all of my running total coming from the (A) Column just to the left of my formula.
I've been doing this many times and the funning thing is I get the exact correct answers I'm looking for and I'm very happy. However. my question is one of learning and curiosity.
Why even though I'm getting the answers I want in the running total does it put an error message in each of the correct answers in each of the cells in the (B) column where I put my formulas.
I tryed to delete the error message spot but I don't know how to delete all of the error spots without going into each cell one by one.
So my question is what am I doing wrong in my formula that's giving me the correct answers but yet Excel is still telling me I have an error?
and how can I get rid of all the error message out of each cell without having to click on each cell one by one to do it when I might have over 500 or more cells to click on.
Thanks for any help you can give me on this one.
Zotah