visible formula
 

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.

visible formula
 

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.

visible formula
 

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.

visible formula
 

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