| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number of non-zero values in a column
Given a column of numbers, is there a formula to return the number of cells
containing a non-zero value? ie. Cells can be empty, contain zero, or contain a number. Nick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of non-zero values in a column
How about this:
=COUNTIF(A1:A100,"<0") HTH, Elkar "Nick Payne" wrote: Given a column of numbers, is there a formula to return the number of cells containing a non-zero value? ie. Cells can be empty, contain zero, or contain a number. Nick |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Number of non-zero values in a column
Thanks. That was almost it. To allow for empty cells, I had to use
=COUNTIF(A1:A100,"<0")-COUNTBLANK(A1:A100) Nick "Elkar" wrote in message ... How about this: =COUNTIF(A1:A100,"<0") HTH, Elkar "Nick Payne" wrote: Given a column of numbers, is there a formula to return the number of cells containing a non-zero value? ie. Cells can be empty, contain zero, or contain a number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate and display the number of values in a column | Excel Discussion (Misc queries) | |||
| MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN | Excel Worksheet Functions | |||
| Look up values in a column and return ALL corresponding row number | New Users to Excel | |||
| can i multipy values in a column by 1 number | Excel Worksheet Functions | |||
| Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
Linear Mode
