Countifs but exclude a particular reference

I'm going to apologize right off the bat. I've never used VBA before but I have used the countifs formula so I'm not sure if I'm going about this the right way. I have an array that I want to count if the cell reference equals a specific name. However, if the name referenced has a strikethrough it, how do I exclude that in the count? I've found other wonderful experts who have shared countstrike or countnostrike codes, but that counts everything with a strike or no strike. My issue is I want to count a specific name in my array without the strike.

I hope that makes sense and if anyone has any insight, I'd appreciate the help. Thank you!

Originally Posted by lisa.pugh

My issue is I want to count a specific name in my array without the strike.

UDF Use in cell like
=CountIfFontAttr(A1:A14,A1,"StrikeThrough",FALSE)

You can also change it like
=CountIfFontAttr(A1:A14,A1,"StrikeThrough",FALSE,"Bold",True,"ColorIndex",3)

Please Login or Register  to view this content.

You are both angels! Thank you so much! I need to refence cells from another sheet and consider other factors in my count. Jindon's worked the simplest for what I needed to accomplish. I appreciate the help! One more question - with the UDF in place, the whole workbook runs slowly even if I'm entering data into a completely different sheet. Is that normal?

Loop through the range getting cell attributes take time, so not recommended.
Adding one column/row to mark, or something else to identify the target would be better.