Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
=SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from
showing up when nothing is in a cell. Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
One of these would be options:
=IF(COUNT(A1:C1)=0,"",SUM(A1:C1)/COUNT(A1:C1)) =IF(COUNT(A1:C1)=0,"",AVERAGE(A1:C1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Richard" wrote: =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
Try this:
=IF(COUNT(A1:C1),AVERAGE(A1:C1),"") -- Biff Microsoft Excel MVP "Richard" wrote in message ... =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
try this
=IF(ISERROR(SUM(A1:C1)/COUNT(A1:C1)),"",SUM(A1:C1)/COUNT(A1:C1)) On Jun 14, 10:10*pm, Richard wrote: =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
Hi,
Why are you making averages complicated, use this =IF(ISERROR(AVERAGE(A1:C1)),"",AVERAGE(A1:C1)) Mike "Richard" wrote: =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
P.S.
If there might be 3 0s in the range you'll still get the error. Or, if there might be a situation like this you'll still get the error: A1 = 10 B1 = -10 C1 = 0 For a generic "catch-all" see Mike's suggestion. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this: =IF(COUNT(A1:C1),AVERAGE(A1:C1),"") -- Biff Microsoft Excel MVP "Richard" wrote in message ... =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
I don't think you really meant this warning.
"T. Valko" wrote: P.S. If there might be 3 0s in the range you'll still get the error. Or, if there might be a situation like this you'll still get the error: A1 = 10 B1 = -10 C1 = 0 For a generic "catch-all" see Mike's suggestion. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this: =IF(COUNT(A1:C1),AVERAGE(A1:C1),"") -- Biff Microsoft Excel MVP "Richard" wrote in message ... =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
If there might be 3 0s in the range you'll still get the error. or perhaps not:) "T. Valko" wrote: P.S. Or, if there might be a situation like this you'll still get the error: A1 = 10 B1 = -10 C1 = 0 For a generic "catch-all" see Mike's suggestion. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this: =IF(COUNT(A1:C1),AVERAGE(A1:C1),"") -- Biff Microsoft Excel MVP "Richard" wrote in message ... =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0!
I don't think you really meant this warning.
You are correct. I didn't mean that at all! <g Time for a break. -- Biff Microsoft Excel MVP "Dave Peterson" wrote in message ... I don't think you really meant this warning. "T. Valko" wrote: P.S. If there might be 3 0s in the range you'll still get the error. Or, if there might be a situation like this you'll still get the error: A1 = 10 B1 = -10 C1 = 0 For a generic "catch-all" see Mike's suggestion. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this: =IF(COUNT(A1:C1),AVERAGE(A1:C1),"") -- Biff Microsoft Excel MVP "Richard" wrote in message ... =SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from showing up when nothing is in a cell. Thanks in advance! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|