how you get the sum by using the mouse

[CC]

sorry in advance but not sure which forum to put this in.

I used to be able to highlight an area of spreadsheet with the mouse and in
the bottom right corner it would say "SUM= the value of all the entries in
the cells."

Since i came back my holidays someones messed about with it nad now it says
"COUNT=the number of cells with values within the chosen range"

Its pretty annoying now as i found the SUM function better for my job
because I sometimes need rough values and can just highlight the area or pick
certain values using the control key.

I've tried looking about in formatting etc but have no idea what to do.

thanks,

CC

[Shatin]

Right-click anywhere on the bar at the bottom, i.e. the bar where you see
the sum or count results. A menu will pop up. Select "Sum" from the menu.

"CC" <CC@discussions.microsoft.com> wrote in message
news:4773DE9B-4296-40F0-A29B-B343E67550F5@microsoft.com...
> sorry in advance but not sure which forum to put this in.
>
> I used to be able to highlight an area of spreadsheet with the mouse and
in
> the bottom right corner it would say "SUM= the value of all the entries in
> the cells."
>
> Since i came back my holidays someones messed about with it nad now it
says
> "COUNT=the number of cells with values within the chosen range"
>
> Its pretty annoying now as i found the SUM function better for my job
> because I sometimes need rough values and can just highlight the area or
pick
> certain values using the control key.
>
> I've tried looking about in formatting etc but have no idea what to do.
>
> thanks,
>
> CC
>
>

[Ray A]

Right click on the count and then see your options. I use sum frequently but
others a useful also
HTH

"CC" wrote:

> sorry in advance but not sure which forum to put this in.
>
> I used to be able to highlight an area of spreadsheet with the mouse and in
> the bottom right corner it would say "SUM= the value of all the entries in
> the cells."
>
> Since i came back my holidays someones messed about with it nad now it says
> "COUNT=the number of cells with values within the chosen range"
>
> Its pretty annoying now as i found the SUM function better for my job
> because I sometimes need rough values and can just highlight the area or pick
> certain values using the control key.
>
> I've tried looking about in formatting etc but have no idea what to do.
>
> thanks,
>
> CC
>
>