COUNTIF for 2 columns
There are no divide operations in that formula, so if you're seeing a
#DIV/0! result it's because you've got a #DIV/0! in the data being used by
the formula. Tackle the problem where it's being generated.
--
David Biddulph
"b1llt" wrote in message
...
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
.
|