I have two different jobs, and I track data on two different
worksheets for the jobs. I am interested in finding out the median
revenue earned for both jobs in each year (combined). I was able to
find the median for each type of job, now I need to know the revenue
for all jobs in each year. How would I set up an equation to do
that? I have the following data on each worksheet (in same workbook):

Columns:
A: Customer Name
B: Customer Number
C: Date Job was Submitted
D: Date Job was Returned
E: Turnaround Time
F: Associate who Completed the Job
G: Revenue from Job


Thanks in advance for your help,


Kevin

=SUMPRODUCT(--(YEAR(Sheet1!C2:C1000)=X1),Sheet1!G2:G1000)+SUMPRO DUCT(--(YEAR(Sheet2!C2:C1000)=X1),Sheet2!G2:G1000)

X1=2007 (year required)

Assumes "Date Job Submitted"

" wrote:

I have two different jobs, and I track data on two different
worksheets for the jobs. I am interested in finding out the median
revenue earned for both jobs in each year (combined). I was able to
find the median for each type of job, now I need to know the revenue
for all jobs in each year. How would I set up an equation to do
that? I have the following data on each worksheet (in same workbook):

Columns:
A: Customer Name
B: Customer Number
C: Date Job was Submitted
D: Date Job was Returned
E: Turnaround Time
F: Associate who Completed the Job
G: Revenue from Job


Thanks in advance for your help,


Kevin

On Jul 7, 12:38 am, Toppers wrote:
=SUMPRODUCT(--(YEAR(Sheet1!C2:C1000)=X1),Sheet1!G2:G1000)+SUMPRO DUCT(--(YEAR(Sheet2!C2:C1000)=X1),Sheet2!G2:G1000)

X1=2007 (year required)

Assumes "Date Job Submitted"

" wrote:
I have two different jobs, and I track data on two different
worksheets for the jobs. I am interested in finding out the median
revenue earned for both jobs in each year (combined). I was able to
find the median for each type of job, now I need to know the revenue
for all jobs in each year. How would I set up an equation to do
that? I have the following data on each worksheet (in same workbook):

Columns:
A: Customer Name
B: Customer Number
C: Date Job was Submitted
D: Date Job was Returned
E: Turnaround Time
F: Associate who Completed the Job
G: Revenue from Job

Thanks in advance for your help,

Kevin


Will this give me the median?