| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Eliminating #DIV/O!
Works like a charm! Thank you for you're help.
"David Biddulph" wrote: May I ask you a question in return? What do you think the SUM function does for you in that formula? In what way do you expect =SUM(AVERAGE(N4:N200)) to differ from =AVERAGE(N4:N200) ? Have you looked in Excel help for the SUM function to see what SUM does? You might try =IF(COUNT(N4:N200),AVERAGE(N4:N200),0) or =IF(ISERROR(AVERAGE(N4:N200)),0,AVERAGE(N4:N200)) -- David Biddulph "MCheru" wrote in message ... I have this formula =SUM(AVERAGE(N4:N200)). Right now #DIV/O! appears if N4:N200 does not have any data to report. Is it possible to modify this formula so that the cell the formula is in reports a zero "0" if it does not have any data to report? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #N/A and eliminating it. | Excel Discussion (Misc queries) | |||
| eliminating records! | Excel Worksheet Functions | |||
| eliminating the 0 in DIV/0 | Excel Discussion (Misc queries) | |||
| Eliminating #N/A | Excel Worksheet Functions | |||
| Eliminating every 25th row | Excel Worksheet Functions | |||
Hybrid Mode
