| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Non Adjacent percent average total
Ok, I don't know what to do to get the cells with I want to average that are
currently blank to show a blank cell if there is no number or a zero in the cells, I think this just sounds confusing. Anywho, this is the formula I have and it's showing a blank cell but that's all it does, or it errors and I can't make it an array. =IF(SUMPRODUCT(--(MOD(ROW(D53:CY53),9)=0),--(D53:CY530))=0,"",AVERAGE(IF((MOD(ROW(D53:CY53),9 )=0)*(D53:CY53<0),D53:CY53))) Anyone know what the problem is? Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| matching the column b(sku)c(count)with A | Excel Worksheet Functions | |||
| Retrieving non adjacent data from other workbooks? | Excel Worksheet Functions | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
Threaded Mode
