| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average over non-existing numbers
You'r welcome - great to have some feed-back!
/Sune "houghi" wrote: Sune Fibaek wrote: Hi Houghi If I'm not misunderstanding you need either one of these formulaes: In the caclutated avg. row use IF(IFERROR(... to eliminate the error messages. Example: =IF(ISERROR(SUM(B2:B3)/COUNT(B2:B3));"";SUM(B2:B3)/COUNT(B2:B3)) will return whatever value is the average of the two cells above or empty if there is an error in the calculation. This will sort your problem of #DIV/0! Works like a charm. Thanks. houghi -- Remind me to write an article on the compulsive reading of news. The theme will be that most neuroses can be traced to the unhealthy habit of wallowing in the troubles of five billion strangers. -- Heinlein |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
| how to add numbers to the left or right of the existing numbers? | Excel Discussion (Misc queries) | |||
| ADDING NEW NUMBERS TO EXISTING WORKSHEET | New Users to Excel | |||
| Doing Sums on existing numbers | Excel Worksheet Functions | |||
| format existing numbers in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
