Sum and Averages by Month

K

KevinGrogan

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.
 
G

Guest

Revenue:

=SUMPRODUCT(--MONTH((C2:C1000)=6),G2:G1000)

will give revenue for jobs submitted in June (assumes only one year)

Turn around:

=SUMPRODUCT(--MONTH((C2:C1000)=6),E2:E1000)/SUMPRODUCT(--MONTH((C2:C1000)=6)

You can put the month (6) in a cell and replace by cell address.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Entries Per Month 5
Median for Year 6
More Median Questions 2
Median Question 4
Compile report from multiple workbooks 6
Calculate hours of work substracting non-working time 2
Pivot Table Calculation 4
SUMIF with NAME RANGE 1

Top