Thread: How to calculate the number of non-zero cells in range?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jasontferrell jasontferrell is offline
external usenet poster
  
Posts: 56
Default How to calculate the number of non-zero cells in range?
Here is one that will account for either blanks or zeros. I wasn't
clear from the original question if we need to exclude both.

=SUMPRODUCT((NOT(ISBLANK(D9:D30))*1)*(NOT(D9:D30=0 )*1))
Reply With QuoteReply With Quote