| Home |
| Search |
| Today's Posts |
|
#7
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 |
| 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 | |||
Threaded Mode
