View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KevinGrogan KevinGrogan is offline
external usenet poster
 
Posts: 8
Default Sum and Averages by Month

How can I set up a formula to calculate the total revenue from jobs
submitted each month and the average turnaround time from jobs
submitted each month? My data is organized below:

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 for your help.