Add multiple vlookup results
Nel post
*Dawn* ha scritto:
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!
I think th best way should by the function SUMIF:
=SUMIF(A2:A4,"Build",B2:B4)
--
Ciao
Franz Verga from Italy
|