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