Donate SIGN UP

Spread Sheets On Excel

Avatar Image
chokkie | 09:13 Tue 05th May 2020 | Technology
8 Answers
Hi techie ABers, I wonder if you can help, please. Mr Chox can just about put a spread sheet together with excel (nothing too complicated though, mind) ... but he is wondering what keys he needs to press to make a total of a column of figures, right at the bottom. Hope someone can help, please. Many thanks, cheers, Chox.
Gravatar

Answers

1 to 8 of 8rss feed

Best Answer

No best answer has yet been selected by chokkie. 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.
Several ways. One is to go in the cell where he wants the total, click on formula, then select SUM, then select the data he wants it to cover
You may also see a Σ symbol on the bar at the top. That is the SUM function
=Sum("Then highlight the range he wants to sum, then" close bracket
The other way is to simply highlight all the figures which provides a total at the bottom of the sheet.
For a non techie I'd suggest a far simpler solution although ff has mentioned it. Highlight the column of numbers and click the sigma symbol that says auto sum over towards top right. That will automatically put the total in the next free cell underneath.
Question Author
That's fantastic folks, really helpful .... where is "formula", please .... - will we see it when we're in the excel programme?

Green row of tabs at the top - File, Home, Insert, Page Layout, Formulas,...
Question Author
Thanks so much, everyone - this information is really helpful. We must definitely widen our computer skills - and you've been a great help. Cheers, Chox (and Mr. Chox) ..

1 to 8 of 8rss feed

Do you know the answer?

Spread Sheets On Excel

Answer Question >>