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?
--
Regards
Roger Govier

"Bernard Liengme" wrote in message
...
Hi Roger
Why did I make it so difficult!
--
Bernard

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Jonathan

Try
=COUNTIF(A2:B6,"*.*")
--
Regards
Roger Govier

"Jonathan Brown" wrote in
message ...
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.