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

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.
 
J

Jonathan Brown

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!
 
R

Roger Govier

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Number of Unique Cells That Don't Have Certain Characters 0
Dealing with the error: unable to filter on excel hc home school 0
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Finding the weighted average of text that have been given values 1
Word macro that can call cells out of Excel for a find and replace 0
How to count the numbers in a Word document? 0
countifs Function not giving desired result with date criteria 2
Excel Countif Function - Calculating Between Two Sets of Values 3

Top