Strike-throughs and equations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 20 May 2008 22:00 GMT

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.

Signature

Kevin

Reply to this Message

T. Valko - 20 May 2008 22:16 GMT

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)

Signature

Biff
Microsoft Excel MVP

> Hello people:
> I need some advice: When you have an equation to sum all the numbers of a
[quoted text clipped - 7 lines]
> time only sum the remaining 8.
> Thanks.

Reply to this Message

Gord Dibben - 20 May 2008 23:09 GMT

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

>Hello people:
>I need some advice: When you have an equation to sum all the numbers of a
[quoted text clipped - 5 lines]
>time only sum the remaining 8.
>Thanks.

Reply to this Message