Hi Brenda,
I don't understand why you need to summarize in sheet 1 information from
sheet2 and then show the results in sheet2 but anyway try this
Let's assume that the material code is in column A sheet2 and amounts in
column B
in sheet 1 column A make a list of your materials starting in row 2 and in
B2 enter this formula

=SUMPRODUCT(--(A2=Sheet2!A2:A13),--Sheet2!B2:B13)

Change the range to fit your needs but remember always the range has to be
the same in both parts of the formula
Then in sheet 2 you can pull the information from sheet1
If this was helpful please say yes. thank you

"Brenda from Michigan" wrote:

Excel 2003 SP3

It's been years since I've had training and this one is just getting away
from me. User has Sheet1 with list of material types and material amounts.
This is setup as a form so neither of these columns is the leftmost column.

He wants to summarize a total of Material A, Material B, etc. on Sheet 2 by
adding the respective amounts of each material in Sheet 1 and showing the
total on Sheet 2. If I could get him to simply copy sheet 1 to sheet 3, then
sort and sub-total, it would be easy, but that's not what he wants. Can
anyone offer any advice? Thanks!