E
evoxfan
I have one cell (X1101) that sums a column of numbers and displays the total
at the bottom of the column. This works fine. If it matters, the column of
cells that X1101 is adding also have sum formulas in them (adding numbers
within its row).
In cell X1103 I tried to make it equal to X1101 with this formula:
X1103=X1101. Very simple, but the display is 0. I tried using an ABS()
formula as well and it displays 0, but if you pull up the formula display
screen it shows the correct number.
Can anyone explain why X1103 displays 0 and how I can correct it as a
reference formula so it will automatically update when something changes? I
could just type the number in but it would not show any updates.
Thanks in advance for your help.
at the bottom of the column. This works fine. If it matters, the column of
cells that X1101 is adding also have sum formulas in them (adding numbers
within its row).
In cell X1103 I tried to make it equal to X1101 with this formula:
X1103=X1101. Very simple, but the display is 0. I tried using an ABS()
formula as well and it displays 0, but if you pull up the formula display
screen it shows the correct number.
Can anyone explain why X1103 displays 0 and how I can correct it as a
reference formula so it will automatically update when something changes? I
could just type the number in but it would not show any updates.
Thanks in advance for your help.