View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth
 
Posts: n/a
Default COUNTIF nonblanks

You could try:

=COUNTIF(A:A,"<")

Regards

Trevor


"dminkov" wrote in
message ...

How to set COUNTIF, in order to count "nonblanks"? Which is the
parameter?
"0" is not the best idea...
And generally, where can I find info about all parameters, used in
Excel functions?

Thank you!


--
dminkov
------------------------------------------------------------------------
dminkov's Profile:
http://www.excelforum.com/member.php...o&userid=17757
View this thread: http://www.excelforum.com/showthread...hreadid=492096