Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
create formula. 1 field constant and another field varies by inpu. | Setting up and Configuration of Excel |