Try PivotTables. Otherwise, by formula...

Assumptions:

A2:C7 contains the source data

F1 contains the data of interest

F3:F4 contains Jane and Bill

I3:I4 contains West

Formulas:

G3, copied down:

=SUMPRODUCT(--($A$2:$A$7=$F$1),--($B$2:$B$7=$I3),--($C$2:$C$7="Q"),--($D$
2:$D$7=$F3))

H3, copied down:

=SUMPRODUCT(--($A$2:$A$7=$F$1),--($B$2:$B$7=$I3),--($C$2:$C$7="O"),--($D$
2:$D$7=$F3))

Hope this helps!

In article . com,
wrote:

Hello Friends - I am searching for a formula that will count how many
quotes and orders Jane is processing on a daily basis for a specific
region. The spreadsheet I am working on has two sheets:

Sheet one looks like this:
A B C D
Date Region Quote/Order Name
10/02/06 East Q Jane
10/02/06 West O Jane
10/02/06 West O Bill
10/02/06 West O Jane
10/02/06 West Q Jane
10/03/06 East O Bill


Sheet two looks like this:


Monday (10/02/06)

A B C D
Name Quote Orders Region
Jane 1 2 West
Bill 1 0 West


Is there a sumproduct formula that will calculate the amount of quotes
and orders Jane has processed for the west region on 10/02/06 in sheet
one onto column B and C of the second sheet? My guess is I am going to
need two formula's: one for column B (Quotes) and one for column C
(Orders).

In this example Jane processed 1 quote and 2 orders for the west region
on 10/02/06.


Any assistance is truly appreciated.


Regards,
Joe