Thread
:
Need to sum values that are not strikethroughs
View Single Post
#
1
Posted to microsoft.public.excel.newusers
Rock
Posts: n/a
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
Reply With Quote