how do I...

[Dave Peterson]

=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???

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Guy Cohen,
Use "SumIF" function:
"=SumIF(B1:B3),"Yes",A1:A3)"
where B1 is equal to the first answer column, B3 is the last answer in
column.
"Yes" is the desired response to count.
A1 is the first value to add in column, A3 is last value to add.

hth

 

[Guy Cohen]

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

 

[Guy Cohen]

Thanks a lot dave
Worked for me
Guy

=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???