If you have a column that contains the "in-house, out-of-house" distinction,
then you could use the SUMPRODUCT formula, something like:

=SUMPRODUCT((C22:C375="ABC")*(D22:D375="IN")*(G22: G375))+SUMPRODUCT((C22:C375="DEF")*(D22:D375="IN") *(G22:G375))+SUMPRODUCT((C22:C375="GHI")*(D22:D375 ="IN")*(G22:G375))

Crude, but works,

Vaya con Dios,
Chuck, CABGx3

"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!