one cell does not reflect a sum
 

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?

one cell does not reflect a sum
 

Instead of =sum(c88:c99),
try in C87:
=SUMPRODUCT((C88:C99+0))
Believe the numbers in C88:C99 are text numbers, not real numbers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"betty in CT" 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?

one cell does not reflect a sum
 

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
__________________________

one cell does not reflect a sum
 

================================================== ===============
Your Numbers don't behave (like numbers)
Niek Otten, May 11, 2006

Your numbers sort incorrectly, are not included in SUMs, cause #VALUE! results in formulas, cannot be found in LOOKUPs, etc.
In short:

Your Numbers look like Numbers, but they really are Text.
Sure! You formatted them as numbers, but alas, formatting afterwards doesn't help. Believe me, they are Text!

Here's a checklist which will help you solve most known cases. Make a copy of your workbook before trying! Always use Excel's
ISNUMBER() function to check your cells; maybe you solved your problem in the first step!

· Format an empty cell as Number. Enter the number 1 in it. EditCopy.
Select your "numbers". EditPaste Special, check Multiply. Hopefully your cells are "real" Numbers now
· If that doesn't help, there may be spaces in your "numbers". You can use the LEN() function to compare the number
of characters that Excel sees in the cell with the number of characters you see. If you suspect spaces, use Excel's TRIM()
function to remove them
· If that doesn't help, there may be nonprintable characters in your "numbers". You can use Excel's CLEAN() function
to remove most of them
· If that doesn't help, there may be non-breaking spaces in your "numbers" (mostly acquired from Web Pages). Use
David McRitchie's TRIMALL() function to remove them. It can be downloaded he
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Please mail me any comments, additions or corrections:

================================================== ===============

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"betty in CT" <betty in wrote in message ...
| 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?

one cell does not reflect a sum
 

C87 can simply be copied across to N87, if you're having the same problem in
the other col ranges. The suggestion presumes you want to leave the source
text numbers data "as-is".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---