Hi Mike,

just a small correction (I first wrote the formula directly on Windows Mail,
without testing...):

=SUMPRODUCT(($A$1:$A$20=E4)*($B$1:$B$20<=F4)*($C$1 :$C$20))/SUMPRODUCT(--($A$1:$A$20=E4))

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy
"Franz Verga" ha scritto nel messaggio
...
Nel ,
Mike R. ha scritto:
hi!
I have a worksheet in which each row is a different job opening with 4
columns = Job, Recruiter, # Days Open, Close Date. I would like to
find the average # of days open for each recruiter within a Close
Date range. On the worksheet, a recruiter may have 10 jobs within a
Close Date range, and I would like to know the average of the ten.

I am toying around with using SUMPRODUCT, but can't get it to work
right. Any help would be great. Thanks in advance.

Mike

Hi Mike,

you could try something like this:

=SUMPRODUCT(($A$1:$A$20=E4)*($B$1:$B$20<=F4)*($C$1 :$C$20))/SUMPRODUCT(($A$1:$A$20=E4))

whe

$A$1:$A$20 is the column for the names;

E4 is the cell with the recruiter you want to examin;

$B$1:$B$20 is the column for the dates;

F4 is the cell for the limit close date;

$C$1:$C$20 is the column for the # Days Open.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy