Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summ figures that are not struck-through
I have a column of figures and a separate cell that displays their sum. I'd
like to be able to exclude from the summing process, the figures in that column that are struck-through. Can anyone suggest a way of doing this? Thanks Andy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summ figures that are not struck-through
hi, Andy !
I have a column of figures and a separate cell that displays their sum. I'd like to be able to exclude from the summing process, the figures in that column that are struck-through. Can anyone suggest a way of doing this? you need the same approach as for sum/count cells with certain color do a google search and you will get a lot of sample "base" code or, if the Font.Strikethrough property is set in a sort of format condition... you could use the same condition to exclude these cells from the summing operation however (AFAIK) there is no any event that can trapp a simple format-change in your cells :-( if any doubts (or further information)... would you please comment ? hth, hector. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summ figures that are not struck-through
Public Function SumNoStrike(rngSumRange As Range) As Single
Dim rngCell As Range 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 On Wed, 2 Jul 2008 16:18:00 -0700, AndyKC wrote: I have a column of figures and a separate cell that displays their sum. I'd like to be able to exclude from the summing process, the figures in that column that are struck-through. Can anyone suggest a way of doing this? Thanks Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are my row numbers/column letters struck through? | Excel Discussion (Misc queries) | |||
summ aumont with interesection with two index.... | Excel Discussion (Misc queries) | |||
Rounding decimals in a summ | Excel Discussion (Misc queries) | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
How can I use SUMIF and AND to test for two conditons before summ. | Excel Worksheet Functions |