I have two columns on my spreadsheet. One that has the employee number for
the jobs that were completed, and the other the day the job was completed. Is
there a way to automate the average of the completed work with the days
worked and the jobs completed? I want to calculate the average number of jobs
that are being completed by each employee over a month.

Hi,

Maybe this,

=SUMPRODUCT((A1:A30=123)*(MONTH(B1:B30)=2))


Where 123 is the employee No and 2 (february) is the month you are looking for

Mike

"IJCVegas" wrote:

I have two columns on my spreadsheet. One that has the employee number for
the jobs that were completed, and the other the day the job was completed. Is
there a way to automate the average of the completed work with the days
worked and the jobs completed? I want to calculate the average number of jobs
that are being completed by each employee over a month.

If you only have the complete date, how would you calculate the days worked,
when does a job start?

--
__________________________________
HTH

Bob

"IJCVegas" wrote in message
...
I have two columns on my spreadsheet. One that has the employee number for
the jobs that were completed, and the other the day the job was completed.
Is
there a way to automate the average of the completed work with the days
worked and the jobs completed? I want to calculate the average number of
jobs
that are being completed by each employee over a month.

On Nov 5, 9:11*am, "Bob Phillips" wrote:
If you only have the complete date, how would you calculate the days worked,
when does a job start?


I would also consider using hours. If there are several jobs/month for
each employee, that suggests that "days worked" is not detailed enough.