How do i see sum of numbers at bottom of workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot see the sum/average etc. of a set of highlighted numbers at the
bottom of the workbook - how do I turn this function on?
 
Right click on the status bar at the bottom of the screen (beneath the sheet
tabs) and select the type of aggregation you want. If it's already set and
you're not getting any totals, it could be that the numbers are stored as
text.
 
Right-click in the status bar and choose your option

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I cannot see the sum/average etc. of a set of highlighted numbers at the
| bottom of the workbook - how do I turn this function on?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing sum bottom of excel window 9
Sum after Filter, Count after Fliter 2
Derive Average 8
SUM TOTALS AT BOTTOM OF WORKSHEET 2
Prevent formula calculation from overriding validation 2
IF AND Nested Functions - Formula Not Working 0
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
HIGHLIGHTED NUMBERS NOT SHOWING SUM AT BOTTOM WANT IT BACK 2

Back
Top