| 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 | |||
Linear Mode
