View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
baklava baklava is offline
external usenet poster
 
Posts: 2
Default sumif and strike through

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!