Need sum total of categories per interval based on agent schedules and their categories

[cph020283]

Hi all,

I would like to have a summed total of categories per time interval based on what agents have the category and their schedule. I wracked my brain trying to figure out how I could do a SUMIFS between two tables but I ultimately failed, and also thought about doing this in a pivot table form but I don't believe that's possible either.

please see attached, thanks!

[JohnTopley]

In F22

=SUMPRODUCT(($F$13:$AE$18=1)*($F$12:$AE$12=F$21)*(INDEX($F$4:$N$9,,MATCH($E22,$F$3:$N$3,0))=1))

Copy across and down

It would have helped if you had provided sample results based on the data rather than a set of random numbers

[cph020283]

Brilliant, I am going to be getting familiar with SUMPRODUCT, INDEX, and MATCH as a result of this. Thank you so much!

[JohnTopley]

You're welcome.

Please mark as SOLVED via "Thread Tools" at top of page.