Hi Dawn

try this

=SUMPRODUCT(--(A2:A5="Build"),(B2:B5))

HTH
Regards from Brazil
Marcelo

"Dawn" escreveu:

I have a spreadsheet that contains names of groups and numerical results for
them as below.
Column A Column B
Frame .50
Build .25
Assy 1 .33
Build 1.5

I need to write a formula that will look for all the occurances of "Build"
and add the numerical amounts together. I've been trying to do it with
vlookup, but maybe that's not the best choice. Does anyone know the best way
to do this?

Thanks!