Thread: How to calculate the number of non-zero cells in range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Claudia d'Amato Claudia d'Amato is offline
external usenet poster
  
Posts: 26
Default How to calculate the number of non-zero cells in range?
I would like to count the number of non-zero (=non-blank) cells in a range (say D9:D30).

How can I do this with an Excel formula ?

Claudia

Reply With QuoteReply With Quote