| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count number of columns based on values across a row
As stated in your previous thread:
=COUNTIF(A2:Z2,"0") -- Best Regards, Luke M "r2rcode" wrote in message ... i need to calcuate the number of columns that have a value greater than zero within a particular row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| How can I count based on 2 values? | Excel Worksheet Functions | |||
| Count number of times two columns have desired values | Excel Discussion (Misc queries) | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
![Luke M[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
