sorry for not being more specific
name of product amount total
a2 b2 c2
and if possible have the value of A2 in a different sheet, when
selecting
A2 and the amoun c2 would calculate the amoun according to the value of
A2 if the value of a2 its 1 0r 3 c2 would calculate and so for
thank you in advance


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=548716