'Disable' Field?
 

I am totaling one row at a time and want to 'disable' a row from the
calculations. Basically, I want to put an "X" (no quotations) in a cell
that will indicate that this cell should not be included in the total.
When I overwrite this cell with a number, I would like it to be automatically
included in the total.

I've tried a number of IIF statements that don't work, can anyone give me
some insight into this?

Thanks, in advance, for your help.

G

'Disable' Field?
 

G wrote:
I am totaling one row at a time and want to 'disable' a row from the
calculations. Basically, I want to put an "X" (no quotations) in a cell
that will indicate that this cell should not be included in the total.
When I overwrite this cell with a number, I would like it to be automatically
included in the total.

I've tried a number of IIF statements that don't work, can anyone give me
some insight into this?

Thanks, in advance, for your help.

G

If you have numbers in A1:D1 and =SUM(A1:D1) in E1, what happens when you put X
in C1? And then replace it with a number?