In my worksheet, I have to total several groups of numbers. I select the sum
function icon and highlight the field. All worked fine except one, which
instead of printing the answer, printed the formula (=SUM H51:H54). I can see
where the cell is formatted any differently than the others.

Caseybay, sounds like the cell was formatted as text, change it to something
else and try it again
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Caseybay" wrote in message
...
In my worksheet, I have to total several groups of numbers. I select the
sum
function icon and highlight the field. All worked fine except one, which
instead of printing the answer, printed the formula (=SUM H51:H54). I can
see
where the cell is formatted any differently than the others.

Casey

This usually indicates that the cell was pre-formatted as Text.

Re-format to General then hit F2 and ENTER to see results.


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 12:53:04 -0700, "Caseybay"
wrote:

In my worksheet, I have to total several groups of numbers. I select the sum
function icon and highlight the field. All worked fine except one, which
instead of printing the answer, printed the formula (=SUM H51:H54). I can see
where the cell is formatted any differently than the others.

I think your problem is the brackets. Reposition the first one so that
it follows the word SUM and Excel will recognize the entry as a
formula.

Instead of having (=SUM H51:H54) change it to read =SUM(H51:H54).


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=478924