| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get rid of the #DIV/O in a cell?
I put in the formula:
(SUM(A1:A6)/(COUNT(A1:A6)-COUNTIF(A1:A6,0))) Some of the worksheets that I put this formula are going to have zero's at times, so how do I change the formula to not have anything in the cell at all instead of #DIV/0? Thanks for your help! |
|
#2
|
|||
|
|||
|
Hi,
=IF(ISERROR((SUM(A1:A6)/(COUNT(A1:A6)-COUNTIF(A1:A6,0)))),0,(SUM(A1:A6)/(COUNT(A1:A6)-COUNTIF(A1:A6,0)))) Basically says that if formula returns an error then value = 0 else redo the formula. Cheers, A -- Please rate my response if you found it helpful. Thanks. "KMHarpe" wrote: I put in the formula: (SUM(A1:A6)/(COUNT(A1:A6)-COUNTIF(A1:A6,0))) Some of the worksheets that I put this formula are going to have zero's at times, so how do I change the formula to not have anything in the cell at all instead of #DIV/0? Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
