yeah sorry fellas had a shocker there.

the formula in the pack qty cell is
=IF(SUM(D64:I64)=0,"",SUM(D64:I64))

and the formula in the cost cell is
=IF(SUM(M64*L64)=0,"",SUM(M64*L64)*12)

i know that total cell formula is correct but aint working until i fix
the other formulas

hope that helps.


--
George.
------------------------------------------------------------------------
George.'s Profile: http://www.excelforum.com/member.php...o&userid=35028
View this thread: http://www.excelforum.com/showthread...hreadid=547722