countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
try
=SUMPRODUCT(--(A1:A100="apple"),--(B1:B100="green"))

You may also take a look at pivot tables
 
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?
 
Back
Top