Thread: Checking for empty cells in a range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roman[_4_] Roman[_4_] is offline
external usenet poster
  
Posts: 93
Default Checking for empty cells in a range
This formula says how many blank cells are there in you range:

=SUMPRODUCT(--(ISBLANK(A7:A30)))

Reply With QuoteReply With Quote