How do I use a countif function according to two other countif fu.

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="value1"),--(rng2="value2"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kirsty" <Kirsty@discussions.microsoft.com> wrote in message
news:4E201C4A-D893-42F7-910F-86D88463FCC9@microsoft.com...
> 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

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:

=A1&"-"&B1

now type the following formula in Col.D

=countif($A$1:$B5, "Apple-Good")


Kind regards.

NAVEEN



"Kirsty" wrote:

> 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