Thread: How do I countif the criteria is a nonblank?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default How do I countif the criteria is a nonblank?
Use COUNTA()

This function counts non-blanks
--
Gary's Student


"Todd" wrote:

A B
$10
$20 $20

How do I get a count of the cells in column B only for the nonblank cells?
Help will be appreciated!
Reply With QuoteReply With Quote