Find Average time to fill - Month to Date

E

Eager2Learn

I am still working with Month To Date data. Here is the formula I a
using to find the number of filled jobs during the current month.

=SUMPRODUCT((MONTH(J$3:J$1000)=MONTH(TODAY()))*(YEAR(J$3:J$1000)=YEAR(TODAY()))*(K$3:K$1000="Ne
Hire"))

Column J = Date Filled
Column K = New Hire or Transfer
Column L has a formula to calculate the number of days it took to fil
the position.

I would like to create a formula similiar to the one above, but I woul
like to find the average time it took to fill the NEW HIRE position
Month to Date.

Help.
Mik
 
F

Frank Kabel

Hi
try
=SUMPRODUCT((MONTH(J$3:J$1000)=MONTH(TODAY()))*(YEAR(J$3:J$1000)=YEAR(T
ODAY()))*(K$3:K$1000="New
Hire"),L$3:L$1000)/SUMPRODUCT((MONTH(J$3:J$1000)=MONTH(TODAY()))*(YEAR(
J$3:J$1000)=YEAR(TODAY()))*(K$3:K$1000="New Hire"))
 

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

Top