i'm trying to generate an automatic form (which will locked down)
within the hiden E columm if have a list of numbers, so when i pick 'p'
(this is a tick mark in wingdings) from a drop-down in columm C, it
automatically aprears in columm D as choosen.
at the bottom of the form all choosen items in columm D need to be
multiplied altogether so i used the product formula -
=PRODUCT(D30:D60)
However because not all of the items in the columm can be choosen at anyone
time - it was coming up as a blank cell - so after looking through this site
I tried this -
=IF(OR(D45:D61=0,D45:E61=""),"",PRODUCT(D45:D61))
to elminate the possible zero being generated
it still doesn't work and i'm at a lost
can anyone help!

--
billy-bob