It sounds like either the SUMIF function and/or the Data SubTotals feature
would be what you are looking for. Check the HELP, and/or post back with
more specifics.

Vaya con Dios,
Chuck, CABGx3



"WeSt39" wrote:


Hi, I am trying to make this spreadsheet, I work for a clothing
manufactorer, I am based out of Honduras Central America. We have
multiple sewing lines, and they produce a certain amount of peices by
size, and by individule "PO's" purchase orders, the individual sizes
are broken up into multiple lines. I am trying to figure out if it's
possible to have a forumla look up certain values by individual line,
that only corrospond to certain PO #'s, and add them together
automaticlly? I know it is difficult to see what I am getting at, so I
made this spread, maybe this will help? thanks!


+-------------------------------------------------------------------+
|Filename: NEWPRODFRM.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4484 |
+-------------------------------------------------------------------+

--
WeSt39
------------------------------------------------------------------------
WeSt39's Profile: http://www.excelforum.com/member.php...o&userid=32629
View this thread: http://www.excelforum.com/showthread...hreadid=524407