Wow, sooo close.

I added a Qty column and then a Price column. Then I used the formula
=(E3*D3) copied down.

Works great except for the cells that have no data, I get a #Value
error. As sson as there is data in the field it all works well enough
for my purpose but how can I hide, or fix this?


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile: http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640