Looks like you have text in B. In D2 enter =ISNUMBER(B2) to test the 8
IF not numbers, try this: Enter 1 in empty cell and copy; select B2:B8 and
use Edit|Paste Special multiply. This generally forces text digits back to
numbers.

Also try formatting B2:B8 as General or number.
Can you use Increase Decimal tool to get 8.00? If not then it is text.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"spiney" wrote in
message ...

Ok, I have a weird problem and have search everywhere I know of. Here it
is.
I have a table that looks like this
_____________________
|Status | Staff | Total_|
|______|_____ |______|
|23____|__8__ |__31__|
|2_____|__3__ |__5___|
|8_____|__1__ |__9___|
|______|_____ |______|
|______|_____ |______|
|7_____|__3__ |__10__|
|______|_____ |______|
|40____|__0__ |______|

Im using =SUM(A2:A8) and =SUM(B2:B8) for the bottom totals (40 and 0
which is supposed to be 15) The B column always sums to 0!!! Why is it
doing this? I have never seen this problem before. Hopefully some of
you have. Any reply would be greatly appreciated! Thanks


--
spiney
------------------------------------------------------------------------
spiney's Profile:
http://www.excelforum.com/member.php...o&userid=31383
View this thread: http://www.excelforum.com/showthread...hreadid=510775