Thread: Count cell except those contain zero
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Count cell except those contain zero
.... or =SUMPRODUCT(--(range<0))
--
David Biddulph

"Ashish Mathur" wrote in message
...
Hi,

=SUMPRODUCT((range0)+(range<0))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manos" wrote in message
...
Dear all

I have a file which include data in more that 5000 lines.
I need to count cell column by column, as number except those cells
contain
zero.

For example olumn b have 5500 but 1500 include zero. So as a result i
should
sse that i have 4000 cells with data.

Thanks in advance for your valuable time.



Reply With QuoteReply With Quote