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.