Trying to hide a product

C

Confused

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.
 
B

Bas

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

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

- Bas
 
C

Confused

Actually took a little time after this post to figure out what I had to do.

Thanks for the input..
 
Top