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