Look up Name in Column A Sheet1 then Sum Colum C Sheet1 then report to column 2 on sheet 2

Please help me with the formula for my scenario below!

Sheet1 Column A will hold the list of names. This list can have the same name multiple times, Sheet1Column 3 holds the data that I need totaled (subtotaled).

Sheet2 Column A will have the names I need pulled from Sheet 1 Sheet2

Sheet 2 ColumnB will hold the subtotal from Sheet 1 Column3

I hope I have described well enough as to what I am looking for.

Thank you for your assistance!

Teresa

With your unique names starting in cell A2 of Sheet2, you could use this formula in B2:

=SUMIF(Sheet1!A:A,A2,Sheet1!C:C)

then copy down as required.

Hope this helps.

Pete

Yes!! Worked like a charm Thank you.

Glad to hear it, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete