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