Thread: How to calculate the number of non-zero cells in range?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
  
Posts: 913
Default How to calculate the number of non-zero cells in range?
On 28 Jul 2009 21:30:25 GMT, (Claudia d'Amato)
wrote:

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


Take a look at the worksheet function COUNTA()

Hope this helps / Lars-Åke
Reply With QuoteReply With Quote