Get highlighted numbers to SUM instead of NUM @bottom of screen?

G

Guest

When you highlight a column of numbers the bottome of the screen shows the
number of cells highlighted. How do I change it to show the SUM of the
highlighted cells?
 
G

Guest

Hi

You need to right-click on that number and a list of otions will appear,
including SUM, AVERAGE etc.

Andy.
 

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

Can you sum cell amounts that are highlighted 3
SUMCOLOR with conditional formatting not working 3
calculate sum of highlighted cells in a column 4
Displaying highlighted cells sum 2
how to count number of highlighted cells in column 5
Sum/total 2
Excel 2002: How to eliminate space within a cell and count items? 6
Counting highlighted cells 2

Top