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

=?Utf-8?B?S2lyc3R5?=
Guest
Posts: n/a

 19th Feb 2006
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

Bob Phillips
Guest
Posts: n/a

 19th Feb 2006
=sumproduct(--(rng1="value1"),--(rng2="value2"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Kirsty" <(E-Mail Removed)> wrote in message
news:4E201C4A-D893-42F7-910F-(E-Mail Removed)...
> 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

=?Utf-8?B?TkFWRUVO?=
Guest
Posts: n/a

 20th Feb 2006
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
4 Orange Good
=================

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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?S2xhdHV1?= Microsoft Access Reports 1 29th Dec 2006 08:15 PM Ingeniero1 Microsoft Excel Worksheet Functions 5 1st Feb 2006 07:43 PM =?Utf-8?B?SmVzc2U=?= Microsoft Access Forms 2 12th Jan 2005 01:20 PM Samantha Microsoft Excel Discussion 1 18th Aug 2004 11:17 AM =?Utf-8?B?R2Vvcmdl?= Microsoft Access 3 22nd Mar 2004 04:24 PM

Features