98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.courses.in.london - Excel
microsoft.excel.courses.in.london - Excel
Resolved · Low Priority · Version Standard
Tue 27 Nov 2007, 09:57Delegate Nick said...
Nick has attended:
Access Introduction course
Excel
Hi
In the right hand corner of the bottom tool bar of excel when you click on a column Excel usually automatically calculates and shows the "sum" of that column when populated with numbers - Excel is currenlty however showing the "count" of the column, not the "sum" - can you please tell me how I change back so that Ecel automatically "sums" rather than "counts"
Cheers
NICK
Tue 27 Nov 2007, 11:06Trainer Richard said...
RE: Excel
Nick
That is pretty simple. Just Right click on the number and you will see a list of functions popup. Choose the one you want and it changes.
Regards
Richard
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |
