| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA
I am trying to formulate a cell to figure averages from cells that have
averages. My current formula reads =AVERAGE(D33,G33,J33,M33,P33,S33,V33,Y33) I am getting the error due to blank cells that have not been filled in yet. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I remove multiple 'errors' in Excel error checking, at the same time??? | Excel Discussion (Misc queries) | |||
| My formula have error, so I remove errors. | Excel Discussion (Misc queries) | |||
| Figuring out a formula | Excel Worksheet Functions | |||
| remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
| Figuring Out A formula to... | New Users to Excel | |||
Threaded Mode
