Thank you for the formulas! However, I cannot get them to work (user
error I am certain). Considering the result I am getting is #name?
Any suggestions?

Regards,
Joe


wrote:
Hello Friends - I am hoping someone can help guide me to the end result
I am trying to accomplish. I am searching for a formula that will
count how many quotes and orders each person is completing on a daily
basis for a specific region.


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/03/06 West Q Jane
10/03/06 East O Bill


Sheet two looks like this:

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

In this example Jane processed one quote and one order on 10/02/06 for
the west region. Is there a formula that will calculate those qty's
from 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).

Your assistance is truly appreciated.

Regards,
Joe