software

I have two countif formulas and I want to count the number of cells that
agree with both of these. Can anyone help please? I've searched the online
help but can't find anything.
Thanks

=sumproduct(--(rng1=quot;value1quot;),--(rng2=quot;value2quot;))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Kirstyquot; gt; wrote in message
...
gt; I have two countif formulas and I want to count the number of cells that
gt; agree with both of these. Can anyone help please? I've searched the online
gt; help but can't find anything.
gt; Thanks
Dear Kirsty,

The problem you stated is not clear. Does it mean that you want to include
two conditions in countif functions i.e., consider the example

A B
=================
1 Apple Good
2 Mango Good
3 Apple Bad
4 Orange Good
5 Mango Bad
=================You want to count the number of Good (Col.B) apples (Col.A).

If this is the problem, you can do it by entering a formula in Col.C as
follows:

=A1amp;quot;-quot;amp;B1

now type the following formula in Col.D

=countif($A$1:$B5, quot;Apple-Goodquot;)Kind regards.

NAVEEN
quot;Kirstyquot; wrote:

gt; I have two countif formulas and I want to count the number of cells that
gt; agree with both of these. Can anyone help please? I've searched the online
gt; help but can't find anything.
gt; Thanks