Count the number of cells that conatin a "." in a range

  • Thread starter Thread starter Jonathan Brown
  • Start date Start date
J

Jonathan Brown

I need a formula, like the countif function, that will count the number of
cells that contain a period. The countif function only looks for exact
matches of the criteria. Is there any way I can put in the criteria a
contains function?

=Countif(A2:B6, contains("."))

I can't imagine this would be difficult.
 
If you'd been sitting with me when I read your answer you'd have seen me
smack myself in the forehead and then subsequently fall out of my chair. It
wasn't pretty. Thanks for such a simple answer!
 
Hi Bernard

Don't beat yourself up.
You should have seen a reply I posted yesterday, which Rick Rothstein
"simplified"!!!
Only occasionally, do I have lucid thoughts<bg>

Are you going to the Summit?
 
Back
Top