=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