Thread: I want to count *'s that i have put in my sheet ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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
...


Reply With QuoteReply With Quote