View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Strike-throughs and equations

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)


--
Biff
Microsoft Excel MVP


"Kevin" wrote in message
...
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.
--
Kevin