| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif >0, specific cells
I need to count specific cells in a row. I had a similar formula to average
the same cells I am now trying to count: =AVERAGE(IF((MOD(COLUMN(Q13:IM13),10)=7)*(Q13:IM13 0),Q13:IM13)) I tried tweaking this to count, but it's just not coming out with a valid answer. Any help would be appreciated. Thanks! Renee. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count cells beginning with specific letter? | New Users to Excel | |||
| keep specific cells from being changed. | Excel Discussion (Misc queries) | |||
| Can specific cells on a worksheet be hidden & password protected? | Excel Worksheet Functions | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Threaded Mode
