count multiple conditions

  • Thread starter Thread starter Jayme
  • Start date Start date
J

Jayme

Here's what I need:

A B
Row-------------
1 2 0 count

2 0 0 don't count

3 0 6 don't count

4 2 4 don't count

5 5 0 count

I want to count if the number in column B is 0, AND if the number in
column A > 0. In this case the correct number would be 2.

I need a formula or array to make this work. Let me know if you have
any answers.

Thanks for your help!

Jayme
 
Hi Jayne,

The famous SUMPRODUCT is what you want

=SUMPRODUCT((A1:A100>0)*(B1:B100=0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
They should devote a whole damn help index to that function alone, giving
examples of all the different uses it an be put to. :-)
 
Bob Phillips said:
They already have, they call it Frank Kabel <vbg>

Bob
Click to expand...

rotflol
If I'll ever have time to set-up my webpage I'll insert a BIG paragraph
for SUMPRODUCT <vbg>
Frank
 
If I'll ever have time to set-up my webpage

How do you get time to sleep, let alone anything else??????????????? :-)
 
If I'll ever have time to set-up my webpage
How do you get time to sleep, let alone anything else???????????????
Click to expand...
:-)

Diffcult question (I better won't ask my wife....) <vbg>
 
Thanks for your help guys. I knew it was a sumproduct function; I was
just too busy to sit down and mess with it. I rely on smarter people
like yourselves. Thanks again.

Jayme
 
Back
Top