| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculations resulting in #DIV/0!
The following example is:
a1 0% a2 0% a3 0% a4 0% a5 0% a6 0% Here's what I have: =sum(a1:a6)/countif(a1:a6,"0") I have multiple cells using this formual that have numbers and function fine. But, with no numbers to calculate against I'm getting the #DIV/0!. How can I fix this so I don't have the #DIV/0!? I've been reading about =IF but I've tried numerous ways and have come up with nothing working. Thanks for your help. Debbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula does not display the resulting value in the cell | New Users to Excel | |||
| Excel adds significant digits, resulting in errors in calculations | Excel Worksheet Functions | |||
| Formula to convert resulting #N/A to 0 | Excel Worksheet Functions | |||
| Formula resulting in 0 | Excel Discussion (Misc queries) | |||
| sumproduct resulting in #N/A | Excel Worksheet Functions | |||
Threaded Mode
