First off, I love this forum, you guys are great.
With that said is there a way to use countif to evaluate a cell and then count those cells unless they have strikethrough formatting?
Example: (Imagine the bold is strikethrough....I couldn't figure out the code for that....[s][/s] didn't work.)
A B1 dog beagle 2 dog mutt 3 cat tabby 4 dog lab 5 dog mix breed 6 dog runt
I need to count the rows with dog but not dog. If that makes sense. It should return 2.
Bookmarks