I'm not sure if I understand your problem right, but perhaps this
works?

=if(AY8<1,sum(AX8:AY8),"")

- Bas


Confused wrote:
What I am trying to do is find the product of 2 cells. The first cell is
actually an error because there is no value until I add one to the previous
cells whereas the second cell has a given value of 1. My problem is in the
product cell where I am getting a value of 1 even though the first cell has
an error in it. (eg. cell AX8 (hidden error), AY8 value 1, AZ8 product shown
as 1 but want that hidden until greater than 1 is present. Then the same "1"
shows up at the end BA8 where there is a =SUM formula.