Instead of doing a strikethough (which, by the way, Excel formulas can not
detect) you could have the formula search for the reason there is a strike
though. Is there a cell that calls out "sent out" or perhaps an "X" somewhere
indicating this? Note that if there is, not only could you build the formula
that way, but you can use conditional formatting to create the strikethrough
effect on your other cells.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"lightbulb" wrote:

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!