On Sat, 16 Sep 2006 07:03:02 -0700, betty in CT <betty in
wrote:

cell b 87 has the formula =sum(c87:n87); cell c87 has the formula
=sum(c88:c99). both cells are reflecting a sum of "0". b87 s/b $7227.33 and
cell c87 s/b $343. Why are these cells not providing the right sums?


The 'numbers' you're seeing are really text.

One way is to put a number 1 in a blank cell, copy it, now select
c87:n87, now Edit--PasteSpecial select the 'multiply' option and
then OK.

Now delete the cell in which you entered the number 1


HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________