Evening All, how do I use the COUNTIF function to count all cells with different random characters except ones with an x in please? Can't get my head round it.
A1 = x
A2 = 6
A3 = ?
A4 = x
A5 = £
Result 3
Many thanks.
Evening All, how do I use the COUNTIF function to count all cells with different random characters except ones with an x in please? Can't get my head round it.
A1 = x
A2 = 6
A3 = ?
A4 = x
A5 = £
Result 3
Many thanks.
Try this:
=COUNTIF(A1:A5,"<>x")
Perfect. Much obliged.
Tried to edit initial post to change to SOLVED but when I press edit the post disappears?????
Happy to help. Thanks for the rep!
Hmm. That's strange.Tried to edit initial post to change to SOLVED but when I press edit the post disappears?????
Are you selecting Thread Tools from the menu link above to mark this thread as SOLVED?
Ah, they've changed how you do it. Sorted. Thanks again.
Gotta keep you on your toes!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks