| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying To Average cells Need Help!!!
This is what i have & works well
{=IF(AR6="L",AVERAGE(IF(AT$6:AT$66=0,AT$6:AT$66)) ,"")} Now what im trying to do is add AW6 IF name is entered I tried these but not working {=IF(AR6="L",IF(AW6"",AVERAGE(IF(AT$6:AT$66=0,AT $6:AT$66)),"")} {=IF(AR6="L",OR(IF(AW6"",AVERAGE(IF(AT$6:AT$66=0 ,AT$6:AT$66)),"")} I get a Name or False error( CAN SOMEONE PLEASE HELP) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to average data if in cells, but ignore blank cells. | Excel Worksheet Functions | |||
| zero value cells/blank cells causing error in AVERAGE? | Excel Worksheet Functions | |||
| from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
| Excel-only average cells if two cells in same row, meet two condit | Excel Worksheet Functions | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
Threaded Mode
