I have multiple rows of employee productivity data in columns A through U.
My employees can select their name from a dropdown and specify a date to see
their productivity. I used versions of the following formula to gather the
specified data:
{=INDEX($R$3:$R$1000,
MATCH(1,($AA$8=$E$10:$E$1000)*($AA$4=$B$10:$B$1000),0))}
AA8 = Agent Name being searched for
AA4 = Date beign searched for
Column R = data value to be selected
Column E = Agent Names
Column B = Dates
I would like to provide weekly and monthly totals as well and already have
data columns(A for month and D for week) that provide that info. Is there a
formula that will total the multiple values that a weekly or monthly search
would find by my array formula above or a modification to my existing array?
|
Similar Threads
