| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Strikethrough
Is there a way to have a formula not include a cell that the text has
strikethrough lines? What I need is if $C$22:$C$375 = abc or = def or = ghi then sum G22:G375 unless strikethgrough has been added to the text by formatting of the cell. It's the only way I could think of for certain cells to sometimes not be added up (if the job is sent out rather than done in-plant) without deleteing the formulas in G22:G375 Any Suggestions? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add strikethrough button to ribbon | Excel Discussion (Misc queries) | |||
| Row and Column Strikethrough | Excel Discussion (Misc queries) | |||
| Can you do strikethrough in excel? | Excel Discussion (Misc queries) | |||
| how can excel recognize strikethrough? | Excel Worksheet Functions | |||
| Strikethrough on Excel. How? | Excel Worksheet Functions | |||
Threaded Mode
