Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |