Sorry, if you have Y/N in column b it should be "=Y" or "=N" in the formula
--
BerbatovIsGod


"PaxtonRoadEnd" wrote:

Type this formula into any cell in column c.

=sumif(b:b,"Yes",a:a)

This works on the entire column, so there is no need to define row numbers.

If, say for example, you wanted to specify a defined range (say) rows 1 to 100
the code would be:

=sumif(b1:b100,"Yes",a1:a100)


BerbatovIsGod


"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