Change divisor if column is 0
This worked - Iwhen I first tried it I entered the wrong cells - DUH. Thanks
again to all.
"Peo Sjoblom" wrote:
Maybe
=SUM(A1:C1)/COUNTIF(A1:C1,"0")
--
Regards,
Peo Sjoblom
"Carol Mac" wrote in message
...
D1=(A1+B1+C1)/3
If A1, B1 or C1 have a 0 value, can the divisor change automatically so
that
it only divides by the number of columns with a value? Thanks.
|