Thanks but this I've tried several simple worksheet and I can only get it to
sum an entire range if the condition is met. I need it to be selective to
the items that meet the condition.

Thanks for you help :)
--
Demetrio


"Don Guillett" wrote:

Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Demetrio Valdez" wrote in
message ...
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