Yes, the quotes were only in the post. The first response helped - apparently
somewhere in the field of cells there was a cell formatted as text instead of
numeric even though I thought I had the whole thing formatted as numbers.

"L. Howard Kittle" wrote:

You show the example in quotes...

If using quotes in the sheet, then remove them, although I suspect you are
just using quotes in your post and not in the worksheet.

HTH
Regards,
Howard

"ryguy7272" wrote in message
...
Right-click the cells you are referencing, and the cell you are doing your
calculation in. Select Format Cells. are any of those cells formatted as
Text? Format as General and try again.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"blessed grandma" wrote:

I have entered this formula in a spreadsheet and wonder why it displays
the
formula "=SUM(E4,E8,E11,E14,E17)" as text?


.