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
Bookmarks