countif

[chappy88]

I am looking for some assistance on a function dilemma.

I have a database with 18 fields.
I have a summary worksheet that collects data from the dbase sheet.
I want to count the number of records that match 2 fields correctly.

Example:
Field A is fruit - oranges, apples, etc.
Field B is color - red, green, etc.

In my summary I want to count the number of records that have green apples.

Any suggestions?

 

[Don Guillett]

try
=sumproduct((a2:a200="apples")*(b2:b200="red"))

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100="apple"),--(B1:B100="green"))

You may also take a look at pivot tables

 

[RagDyeR]

Enter the fruit to find in C1.
Enter the color to find in C2.
And try this:

=SUMPRODUCT((A1:A100=C1)*(B1:B100=C2))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am looking for some assistance on a function dilemma.

I have a database with 18 fields.
I have a summary worksheet that collects data from the dbase sheet.
I want to count the number of records that match 2 fields correctly.

Example:
Field A is fruit - oranges, apples, etc.
Field B is color - red, green, etc.

In my summary I want to count the number of records that have green apples.

Any suggestions?