| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation Problem
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
Threaded Mode
