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

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: How do i sum values according to specific value from other field?	=?Utf-8?B?S2xhdHV1?=	Microsoft Access Reports	1	29th Dec 2006 08:15 PM
COUNTIF according to presence of string within text	Ingeniero1	Microsoft Excel Worksheet Functions	5	1st Feb 2006 07:43 PM
How to search for a form according to a field other than record nu	=?Utf-8?B?SmVzc2U=?=	Microsoft Access Forms	2	12th Jan 2005 01:20 PM
summing a column according to criteria of two other columns	Samantha	Microsoft Excel Discussion	1	18th Aug 2004 11:17 AM
Changing a Field in one table according to the other	=?Utf-8?B?R2Vvcmdl?=	Microsoft Access	3	22nd Mar 2004 04:24 PM