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

Excel Use COUNTIF across a range of cells with formulas 0
Count range of cells if not next to each other 0
count based on single number 13
How to count cells which contain a formula that returns TRUE 15
Countif with a Range of criteria 8
Counting Multiple Text Cells 4
Count text then add results 2
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7

Top