=sumif(b:b,"y",a:a)
or
=sumif(b:b,"yes",a:a)

You wrote yes/no in the text, but you used y/n in the sample???



Guy Cohen wrote:

Hi all
In column A I have numbers
In column B I have two values : "Yes"/"No"
I want C1 to contain SUM(A) but only if B has "Yes"

e,g,

A B C
1 Y 5
2 N
4 Y

TIA
Guy

--

Dave Peterson