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.

Hi,

It;s simpler than that, put this in X1103

=X1101

Mike

"evoxfan" wrote:

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.

Use IF(<formula=0,"",<formula)
--
If this post helps click Yes
---------------
Jacob Skaria


"evoxfan" wrote:

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.

That is exactly the formula I currently have which displays "0".

It blew my mind why it would display "0" when that is not the answer in X1101.

"Mike H" wrote:

Hi,

It;s simpler than that, put this in X1103

=X1101

Mike

"evoxfan" wrote:

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.

I am not sure whether I have understood you question correctly..
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Use IF(<formula=0,"",<formula)
--
If this post helps click Yes
---------------
Jacob Skaria


"evoxfan" wrote:

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.