I knew it had to be something simple, or maybe i just found a work around. heres the formula i used
=IF(SUM(I11:O11)=0,"",SUM(I11:O11)*Q10)
=IF(SUM(I11:O11)=0,"",SUM(I11:O11)*R10)
they gave the values for the wholesale and retail values but left the corresponding cells clear until information...