MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vlookup or ??


Posted by sandra on November 15, 2001 8:28 AM

column A has Bag Nos column B has Values vlookup will put these in order but not reconise more bags with the same No therefore if Column A has a bag No 147 with 4 entries how do i add the values in column B together before using vlookup remembering each week the cell that 147 is in will be different


Posted by Dan on November 15, 2001 8:44 AM

Not sure I understand completely...
Use SUMIF to sum totals in column B when the corresponding cell in column A = 147.

=sumif(A:A,"147",B:B)

Posted by sandra on November 16, 2001 4:32 PM

Posted by sandra on November 16, 2001 4:36 PM

thanks Dan that is spot on what i need
many many thanks have a nice xmas

Posted by Thanks Dan iam new to this message return on November 16, 2001 4:41 PM

many thanks it worked a treat so far happy new year