Multiple Worksheets & Column addition error
Posted by Diana on January 30, 2002 8:27 AM
I have a rather large workbook/sheet that combines (totals) 3 other workbooks with 17 worksheets each.
It is working well transferring all the info to the one workbook/sheet, but when I have the columns total the sum is off anywhere by anywhere from 1 to 4. I thought it might be a rounding problem, so I changed it to see and it doesn't appear to affect the final total.
Does anyone know why this worksheet won't total the actual numbers in each cell (even though they refer to other workbooks/cells)?
Thanks in advance for any help at all! :)