Try this

=IF(sum(C8:E8)=0,"",sum(C8:E8)/3)
--
HTH...

Jim Thomlinson


"MWH" wrote:

Here is a calculation if I want it to show no value (Blank) what do I need
to add?

=SUM(C9:E9)/3

I've tried this =IF(C8:E8/3=0,"",C8:E8/3=0) and I get a $VALUE! error

--
Mark W. Hanford