View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan B
 
Posts: n/a
Default Countif question

Hi,
I'm using this formula to count empty rows in a column:
=countif(A2:A1000,"")

In another column, I want to count the rows that are not empty. What do I
need to change in this formula to do that?

Thanks