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.