Click on the Ribbon's Home tab
Look over to the right - the Edit group
The symbol in top left corner is Sigma ? (a bit like a 'funny' E)
Click it and you get =SUM(.....
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"normike" wrote in message
...
I'm new at this & having some problems accessing forums but have a related
question to the mouse. When I right click a cell in Excel 2007 a box opens
up
with some choices. Is there any way of inserting the Sum function into
this
box?

"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