=Sumproduct((b1:b10)="yes")*(a1:a10))

will sum values in A when B=Yes

HTH

"Demetrio Valdez" wrote:

I am trying to use vlookup to find all the item that equal a yes or no in a
table, and I want it to sum.
For example
table
1 yes
1 no
1 yes

I can only get voolkup to pull a "1" value", how do I get it to sum all the
yes values?
Is there another function that I should use?

--
Demetrio