I have a workbook with 2 tabs.
#1 tab contains all of the data w/ Names and dollar amounts. The Names are duplicated numerous times.
For example:
Smith 50.00
Cantrell 65.00
Smith 10.00
Smith 5.00
Cantrell 7.00
#2 tab is summarizing. I have one column that states the Name - and I need the 2nd column to look up that name and list the total dollars
For example:
My spreadsheet looks like:
Name: Total Dollars:
Smith
Cantrell
and I need it to look like:
Name: Total Dollars:
Smith 67.00
Cantrell 72.00
I think if I could figure out a combination of Vlookup and Sumif (or maybe Sumproduct) that it would work - but I can't seem to figure it out.
Thanks,
aspears
Bookmarks