Sumprodcut not working for me...please help
 

Column L either has a number in it or it is blank. Column N has the word
play in it or it is blank. I would like to count up the number of cells in
column L that have a 1 in them only if the corresponding cell in column N has
the word play in it. I tried this formula
(=SUMPRODUCT(L2:L83=1,N2:N83="PLAY")) but it isn't working. Any ideas?
Thanks

Sumprodcut not working for me...please help
 

=SUMPRODUCT(--(L2:L83=1),--(N2:N83="PLAY"))


"Jambruins" wrote:

Column L either has a number in it or it is blank. Column N has the word
play in it or it is blank. I would like to count up the number of cells in
column L that have a 1 in them only if the corresponding cell in column N has
the word play in it. I tried this formula
(=SUMPRODUCT(L2:L83=1,N2:N83="PLAY")) but it isn't working. Any ideas?
Thanks

Sumprodcut not working for me...please help
 

=SUMPRODUCT((L2:L83=1)*(N2:N83="PLAY"))

--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
Column L either has a number in it or it is blank. Column N has the word
play in it or it is blank. I would like to count up the number of cells
in
column L that have a 1 in them only if the corresponding cell in column N
has
the word play in it. I tried this formula
(=SUMPRODUCT(L2:L83=1,N2:N83="PLAY")) but it isn't working. Any ideas?
Thanks

Sumprodcut not working for me...please help
 

Thanks that worked but I realized I wrote my question wrong. I would Column
M has either a W, L, or blank. I would like to count all the cells in column
L that have a 1 in them only if the corresponding cell in column M has a W or
an L in it. Thanks.

Sumprodcut not working for me...please help
 

=SUMPRODUCT((L2:L83=1)*(M2:M83={"W","L"}))



--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
Thanks that worked but I realized I wrote my question wrong. I would
Column
M has either a W, L, or blank. I would like to count all the cells in
column
L that have a 1 in them only if the corresponding cell in column M has a W
or
an L in it. Thanks.

Sumprodcut not working for me...please help
 

thanks, works perfectly

"Don Guillett" wrote:

=SUMPRODUCT((L2:L83=1)*(M2:M83={"W","L"}))



--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
Thanks that worked but I realized I wrote my question wrong. I would
Column
M has either a W, L, or blank. I would like to count all the cells in
column
L that have a 1 in them only if the corresponding cell in column M has a W
or
an L in it. Thanks.

Sumprodcut not working for me...please help
 

Glad to help

--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
thanks, works perfectly

"Don Guillett" wrote:

=SUMPRODUCT((L2:L83=1)*(M2:M83={"W","L"}))



--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
Thanks that worked but I realized I wrote my question wrong. I would
Column
M has either a W, L, or blank. I would like to count all the cells in
column
L that have a 1 in them only if the corresponding cell in column M has
a W
or
an L in it. Thanks.