| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count the number of rows with entries greater than zero
i need a formula that will look at the information in a range of column
within a row. if the number in a column is greater than zero, then i need to add one to the total. this will allow me to know the number of columns with values greater than zero. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count the number of rows with entries greater than zero
=COUNTIF(A2:Z2,"0")
-- Best Regards, Luke M "r2rcode" wrote in message ... i need a formula that will look at the information in a range of column within a row. if the number in a column is greater than zero, then i need to add one to the total. this will allow me to know the number of columns with values greater than zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count filtered rows based on condition greater than forty | Excel Worksheet Functions | |||
| Count of Number Values Greater Than, Less Than | Excel Worksheet Functions | |||
| Charting when number of rows are greater than 65536 | Charts and Charting in Excel | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
Linear Mode
