I want to count *'s that i have put in my sheet ?

H

harry cheema

Thanks for Help
But not
=COUNTIF(A:A,"~*")
BUT
=COUNTIF(A:A,"**")
WORKS.
THANKS PEO
HARRY
 
P

Peo Sjoblom

Not really unless you really wanted to count all cells that are not empty

=COUNTIF(A:A,"~*")

will count cells that contain the asterisk and nothing else



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

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

Can I sort Excel sheet by the color of the fill in selected cell 0
i want to do a vlookup but i want the table array to be changing 2
Vlookup and return sheet name also 2
useing excel How can I type in the pi symbole? 2
how do I make a list of the names of worksheets in an excel workb 1
Counting with multiple matching criteria 12
countif problem - am I bonkers? 3
Counting cells with text not listed. 2

Top