More Questions Sums and Averages by Date
 

How can I set up a formula to calculate the total revenue per month
and the
average turnaround per 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.

More Questions Sums and Averages by Date
 

How can I set up a formula to calculate the total revenue per month
and the
average turnaround per month? My data is organized below:

What do you mean by "per month"? For example, what if you total revenue for
a job was $1000 and the job lasted from June 1st to June 15th... was your
total revenue per month $1000 divided by 1/2 month ($2000 per month) or
$1000 divided by the total month ($1000 per month)? What about it job
spanned 2 months (May 24th to June 8th)? What if those 15 days crossed from
February into March of a leap or non-leap year?

Rick

More Questions Sums and Averages by Date
 

On Jul 4, 9:32 am, "Rick Rothstein \(MVP - VB\)"
wrote:
How can I set up a formula to calculate the total revenue per month
and the
average turnaround per month? Mydatais organized below:

What do you mean by "per month"? For example, what if you total revenue for
a job was $1000 and the job lasted from June 1st to June 15th... was your
total revenue per month $1000 divided by 1/2 month ($2000 per month) or
$1000 divided by the total month ($1000 per month)? What about it job
spanned 2 months (May 24th to June 8th)? What if those 15 days crossed from
February into March of a leap or non-leap year?

Rick

I'm sorry....I wasn't very clear. I have revenue from each job
listed. The revenue from a job submitted June 30 but not finished
until July 4 is counted as June revenue. I want to add up the revenue
from all jobs submitted for each month.

More Questions Sums and Averages by Date
 

On Jul 4, 5:41 pm, KevinGrogan wrote:
On Jul 4, 9:32 am, "Rick Rothstein \(MVP - VB\)"

wrote:
How can I set up a formula to calculate the total revenue per month
and the
average turnaround per month? Mydatais organized below:

What do you mean by "per month"? For example, what if you total revenue for
a job was $1000 and the job lasted from June 1st to June 15th... was your
total revenue per month $1000 divided by 1/2 month ($2000 per month) or
$1000 divided by the total month ($1000 per month)? What about it job
spanned 2 months (May 24th to June 8th)? What if those 15 days crossed from
February into March of a leap or non-leap year?

Rick

I'm sorry....I wasn't very clear. I have revenue from each job
listed. The revenue from a job submitted June 30 but not finished
until July 4 is counted as June revenue. I want to add up the revenue
from all jobs submitted for each month.

I also need to know (for each month) what the average turnaround time
per job was.

Thanks again,

Kevin