I don't think it's possible to do this directly. SUMIF (and other functions)
work on conditions - strikethrough is simply a formatting tool and doesn't
affect the condition of the cell contents.

Perhaps you could include a neighbouring column to hold some
symbol/number/text as well as striking through the original cell. This value
could then be used by SUMIF to determine which cells to incorporate. If you
found this additional column presentationally intrusive, you could make it
invisible via conditional formatting or by hiding the column, though it's
then difficult to visually check that you've set all the correct trigger
points.

"baklava" wrote:

I have a column of numbers that I want to total; however, some of the rows
have the number struck through - these are the numbers I DO NOT want to
include in the total.

=sumif(a1:a20, and here is where I get stuck. How do I tell excel to sum
all the numbers in the range except those that have strike through.

Or is there a different formula to use?

Thanx!