ChatterBank13 mins ago
adding columns of numbers
i 'm having a senior moment !! i've forgotten how to do it .can anyone refresh my memory?
Answers
Best Answer
No best answer has yet been selected by glenis. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.sorry i still have total memory loss ,i've done that and still no total ,all i get in the cell is =sum(A2:A17) but no total. i have microsoft excel with autosum ,i click the autosum on the toolbar which then prompts me for the cell numbers ,which i then type in ,then click autosum again and i get a total of 0 i know i am doing something really silly but can't figure out what it is
If the numbers to be added are there already you shouldn't be asked to type a cell number when using autosum, sorry I presumed the figures had been input .
Ethels method should definitely work if you are setting up a spreadsheet for inputting details later.
You could try putting just one row of figures in as an experiment and trying autosum in the method I suggested. Other than that I'm lost I'm afraid, sorry.
Ethels method should definitely work if you are setting up a spreadsheet for inputting details later.
You could try putting just one row of figures in as an experiment and trying autosum in the method I suggested. Other than that I'm lost I'm afraid, sorry.