I should have mentioned we're still on Excel 2000.
I used these and am getting a #DIV/0! result.
Any suggestions ---thanks,
Bill

"Ziggy" wrote:

Another 2003 solution is an array formula

=SUM(($K$15:$K$38=K41)*($M$15:$M$38=1))

Set with CTRL-Shift-Enter
.