How do I add cells by highlighting them?
 

Normally, I can add numbers in different cells by highlighting those cells.
The sum will then appear at the bottom of my screen.

For some reason, my excel program has stopped doing this. Now, when I
highlight multiple cells with my cursor, excel only adds up the number of
cells. For instance, if I highlight 5 cells, it will say "count = 5."

I'd really like to be able to sum totals by highlighting cells again. How do
I get this function back?

How do I add cells by highlighting them?
 

hi
right click the status bar (the bar where the sum appears)
from the popup, click sum.

you may want to make not of all of the other options available.

regards
FSt1

"Tim" wrote:

Normally, I can add numbers in different cells by highlighting those cells.
The sum will then appear at the bottom of my screen.

For some reason, my excel program has stopped doing this. Now, when I
highlight multiple cells with my cursor, excel only adds up the number of
cells. For instance, if I highlight 5 cells, it will say "count = 5."

I'd really like to be able to sum totals by highlighting cells again. How do
I get this function back?

How do I add cells by highlighting them?
 

right click on that area where the count result is and select..........


--
Greetings from New Zealand

"Tim" wrote in message
...
Normally, I can add numbers in different cells by highlighting those
cells.
The sum will then appear at the bottom of my screen.

For some reason, my excel program has stopped doing this. Now, when I
highlight multiple cells with my cursor, excel only adds up the number of
cells. For instance, if I highlight 5 cells, it will say "count = 5."

I'd really like to be able to sum totals by highlighting cells again. How
do
I get this function back?