Given the following data in a spreadsheet, is it possible to sum all the red
pencils, all the blue pencils, and all the green pencils if the number of
lots for each color varies? I'm hoping there's a way to sum samples based on
the criteria "unique".


Column 1 Column 2

color: # in each lot:
red 200
red 100
red 50
blue 350
green 200
green 210
green 75

--
Sometimes to have a little good luck is the most brilliant plan.