I have multiple worksheets with lists of parts and quantities attached to
them. Many of the worksheets have the same parts on them, is there a way to
create a worksheet with consolidated quantities for each part? I'm
thinking this will be a complicated formula, because the parts are not always
in the same row (but they are in the same column). Something like,
=(IFA1="JANTX1N622S",THENA2) for each part, where A2 is the quantity and A1
is the part? But then I need to total all the A2's over all the worksheets.

TIA
Scott

What are the sheet names?

--
Regards,
Tom Ogilvy

"Scott University of Colorado" <Scott University of
wrote in message
...
I have multiple worksheets with lists of parts and quantities attached to
them. Many of the worksheets have the same parts on them, is there a way
to
create a worksheet with consolidated quantities for each part? I'm
thinking this will be a complicated formula, because the parts are not
always
in the same row (but they are in the same column). Something like,
=(IFA1="JANTX1N622S",THENA2) for each part, where A2 is the quantity and
A1
is the part? But then I need to total all the A2's over all the
worksheets.

TIA
Scott