| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracking Date/Actual Working Time Elapsed | Excel Worksheet Functions | |||
| Highlighted Reference Cell for a Working Cell | Excel Worksheet Functions | |||
| Sumproduct suddenly not working | Excel Discussion (Misc queries) | |||
| Calling another workbook not working | Excel Worksheet Functions | |||
| how do I adjust working calendar (6 day work week) in excel that . | Excel Worksheet Functions | |||
Linear Mode
