Strike-throughs and equations

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hello people:
I need some advice: When you have an equation to sum all the numbers of a
column, is there some way that when you use a strike-through (part of the
fonts), that the number that now has the strike-through can be not-included
in the summation or is this impossible?
IE: There is a list of 10 items in the sum equation, but you want to
'cross-off' 2 of them, but not remove them from the list, while at the same
time only sum the remaining 8.
Thanks.
 
How about an easier alternative?

Use an adjacent column and mark values to exclude with a "X" :

...........A..........B
1....................10
2........X.........10
3........X.........20
4....................15
5....................10

=SUMIF(A1:A5,"<>X",B1:B5)
 
Public Function SumNoStrike(rngSumRange As Range) As Single
Dim rngCell As Range
For Each rngCell In rngSumRange
If IsNumeric(rngCell.Value) Then
If rngCell.Font.Strikethrough = False Then
SumNoStrike = SumNoStrike + rngCell.Value
End If
End If
Next rngCell
End Function

=SumNoStrike(range)


Gord Dibben MS Excel MVP
 
Back
Top