how do I...
 

=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

how do I...
 

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

how do I...
 

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

how do I...
 

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" 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

how do I...
 

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

how do I...
 

Thanks a lot dave
Worked for me :)
Guy
"Dave Peterson" wrote in message
...
=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