You will get the "#VALUE!" Error when G8 cell is having any Text String. The
=SUM(B8:C8) will not get the "#VALUE!" error.

--------------------
(Ms-Exl-Learner)
--------------------


"datub" wrote:

My formula is =SUM(B8:C8)*G8 where either B8 or C8 will always =0. How do I
not get this value" #VALUE!" when the cells are not in use?