How do I delete numbers in a cell
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" wrote in message
...
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
|