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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to count *'s that i have put in my sheet ? (https://www.excelbanter.com/excel-worksheet-functions/79768-i-want-count-%2As-i-have-put-my-sheet.html)

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

Precede with a tilde to make it work

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"harry cheema" <harry wrote in message
...

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

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

"Peo Sjoblom" wrote:

Precede with a tilde to make it work

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"harry cheema" <harry wrote in message
...

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

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

"harry cheema" wrote in message
...
Thanks for Help
But not
=COUNTIF(A:A,"~*")
BUT
=COUNTIF(A:A,"**")
WORKS.
THANKS PEO
HARRY

"Peo Sjoblom" wrote:

Precede with a tilde to make it work

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

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"harry cheema" <harry wrote in message
...