| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cell except those contain zero
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cell except those contain zero
Try
=COUNT(A:A)-COUNTIF(A:A,0) OR =COUNTIF(H:H,"0")+COUNTIF(H:H,"<0") 'if you have only positive numbers the below will do =COUNTIF(H:H,"0") If this post helps click Yes --------------- Jacob Skaria "Manos" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cell except those contain zero
It works perfectly.
Thank you very much "Jacob Skaria" wrote: Try =COUNT(A:A)-COUNTIF(A:A,0) OR =COUNTIF(H:H,"0")+COUNTIF(H:H,"<0") 'if you have only positive numbers the below will do =COUNTIF(H:H,"0") If this post helps click Yes --------------- Jacob Skaria "Manos" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count cell except those contain zero
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Hybrid Mode
