hi
=sumif(A2:A8,"red",B2:B8)

or

=sumproduct((A1:A8="red")*(B2:B8))

you'll need a formula for each color(criteria)

Regards
FSt1

"LindaJane" wrote:

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.