Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum a column ignoring cells strikedthrough
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum a column ignoring cells strikedthrough
Tracey,
With a UDF in VBA: Function SUMstrike(inR As Range) As Double Dim myC As Range For Each myC In inR If Not myC.Font.Strikethrough Then SUMstrike = SUMstrike + myC.Value End If Next myC End Function used like =SUMstrike(A2:A100) Note that changing the font of a cell to strikethrough does not fire a calculation, so you will need to change something else (renenter a number in the range) or do a manual re-calc. HTH, Bernie MS Excel MVP "Tracey" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum ignoring cells with error | Excel Worksheet Functions | |||
How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
Counting Names in a Column, Ignoring Duplicates | Excel Discussion (Misc queries) | |||
Ignoring blanks from Column(s) | Excel Worksheet Functions | |||
Ignoring Blank Cells | Excel Worksheet Functions |