SUM problem

  • Thread starter Thread starter R0bert0
  • Start date Start date
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!
 
=SUMPRODUCT(('range of part #'s'="part #')*('range of machine #'s'='machine
#')*('range of quantity produced'))

Replace the descriptions with the appropriate ranges. For the formula to
work all ranges must contain the same number of rows.
 
Back
Top