R
R0bert0
I have two workbooks. One is a daily production plan and various othe
spreadsheets related to this and the other is a daily production recor
which is download into excel via an AS/400 system.
The plan is separated into sections each with its own header, accordin
to the machine number, such as "Press #20 500 TON"
Is there a formula I can put into the production plan sheet that wil
sum the data from the production record sheet if it matches
criteria??
I need it to sum the quantity produced if it matches the part numbe
AND the machine number.
Hope I've explained that well enough.
Thanks!
spreadsheets related to this and the other is a daily production recor
which is download into excel via an AS/400 system.
The plan is separated into sections each with its own header, accordin
to the machine number, such as "Press #20 500 TON"
Is there a formula I can put into the production plan sheet that wil
sum the data from the production record sheet if it matches
criteria??
I need it to sum the quantity produced if it matches the part numbe
AND the machine number.
Hope I've explained that well enough.
Thanks!