Find Average time to fill - Month to Date

[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

 

[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"))