How do I delete numbers in a cell

[Therese]

I have two rows, one with numbers A, and one empty B. I put "x" in B, when I
need to show that the payments in A has been done.
How do I make the numbers dissapear? I have formatted A so that the numbers
in A gets white when I write "x" in B so the numbers don't show. But the
numbers are still there(althoug hidden), and the sum in the bottom don't
change.
Is there a formel I can use?
Great if you know!
--
Therese

[Gary''s Student]

Instead of putting values in A like 123.45, put a formula like:

=IF(B1="x","",123.45)

When you change the B's the A's will really vanish.
--
Gary's Student


"Therese" wrote:

> I have two rows, one with numbers A, and one empty B. I put "x" in B, when I
> need to show that the payments in A has been done.
> How do I make the numbers dissapear? I have formatted A so that the numbers
> in A gets white when I write "x" in B so the numbers don't show. But the
> numbers are still there(althoug hidden), and the sum in the bottom don't
> change.
> Is there a formel I can use?
> Great if you know!
> --
> Therese

[Mangesh Yadav]

Suppose your numbers are in column A, and you enter x in column B, then use
a formula something like this:

=SUMIF(B1:B4,"<>x",A1:A4)

This will sum only those cells that do not have an adjoinin x in it.

Mangesh




"Therese" <[email protected]> wrote in message
news:[email protected]...
> I have two rows, one with numbers A, and one empty B. I put "x" in B,
when I
> need to show that the payments in A has been done.
> How do I make the numbers dissapear? I have formatted A so that the
numbers
> in A gets white when I write "x" in B so the numbers don't show. But the
> numbers are still there(althoug hidden), and the sum in the bottom don't
> change.
> Is there a formel I can use?
> Great if you know!
> --
> Therese