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 types of 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

I tried the formula below, but it gave me a number that couldn't be
the median:

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


Thanks in advance for your help,

Kevin