this is kind of hard to explain so I attached a sample book...
Need to lookup the values in table1 column A in table2, and depending on givin criteria sum the numbers in the table2 for the given Column A values
can explain more if needed -- would prefer no help columns, using excel 2010
Bookmarks