View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Rock
 
Posts: n/a
Default Need to sum values that are not strikethroughs

I need to sum a column without it adding the rows that have strikethroughs
values; is it possible to combine a formula and vb code to a cell ?

=SUM(BH100:BH120) & Activecell.selection.font.strikethrough = false

Thank you
Khf