Count IF function (Excel 2000)

Topic

New Reply

I’ve got a list of names and a COUNTA formula that just counts the names in the list. I would like a formula that does not count a name if I use strikethrough to show that the person is not coming to the conference.

Reply | Quote

Replies

This User Defined Function will do what you asked:

Public Function CountNS(oRng As Range) As Long
Dim ocell As Range
    For Each ocell In oRng
        If Not ocell.Font.Strikethrough Then
            CountNS = CountNS + 1
        End If
    Next ocell
End Function

Reply | Quote