More Median Questions

  • Thread starter Thread starter KevinAGrogan
  • Start date Start date
K

KevinAGrogan

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)+SUMPRODUCT(--(YEAR(Sheet2!C2:C1000)=X1),Sheet2!G2:G1000)

X1=2007 (year required)

Assumes "Date Job Submitted"
 
=SUMPRODUCT(--(YEAR(Sheet1!C2:C1000)=X1),Sheet1!G2:G1000)+SUMPRODUCT(--(YEAR(Sheet2!C2:C1000)=X1),Sheet2!G2:G1000)

X1=2007 (year required)

Assumes "Date Job Submitted"
Click to expand...


Will this give me the median?
 
Back
Top