M
MC
I have a workbook that contains a simple 3D reference that sums the
worksheets between A and B. For the majority of this workbook, on the total
tab, it is calculating the formulas correctly, but in a few spots it is
calculating some random number. The formula is correct and when you manually
add the two numbers together, it should be 0, but the formula is returning
$12060. I have gone back to the worksheets between A and B and checked to
make sure that the numbers in the cell were 0 and they are. Would inserting
rows affect the formula? The rows were inserted accross all the tabs in the
exact same place and then the formulas were correctly updated.
I have check the formula over and over again and it is correct. Here is an
example of what it is doing:
=SUM(A:B!D69)
Total Tab: A Sheet 1
Sheet 2 B
$12060 $0
$0
Any help would be greatly appreciated.
worksheets between A and B. For the majority of this workbook, on the total
tab, it is calculating the formulas correctly, but in a few spots it is
calculating some random number. The formula is correct and when you manually
add the two numbers together, it should be 0, but the formula is returning
$12060. I have gone back to the worksheets between A and B and checked to
make sure that the numbers in the cell were 0 and they are. Would inserting
rows affect the formula? The rows were inserted accross all the tabs in the
exact same place and then the formulas were correctly updated.
I have check the formula over and over again and it is correct. Here is an
example of what it is doing:
=SUM(A:B!D69)
Total Tab: A Sheet 1
Sheet 2 B
$12060 $0
$0
Any help would be greatly appreciated.