Looking for multiple values in multiple arrays.

[Quasar82]

Hi Guys,

I have 26 tasks to be finished in a given amount of time by 5 people. Each task can be done in maximum of 3 takes (minimum 1). All 5 people are assigned different number of tasks depending on their availability & experience.

Take 1 is considered as Original while take 2 & 3 are retakes.


I want to calculate Take 1 & Retakes done by each person (of 5) for all 26 tasks.

I manually calculated (TK2 & TK3 for 5 of them) in a table in cells between H36:K41 in the attachment. Values in Red should be calculated automatically.


Name------------ TK1 TK2 TK3

Alice Tinn-------- 122- 35-- 12
Fred Jackson---- 104- 10-- 0
John Hammond- 35-- 4--- 0
Oliver Quinn----- 65-- 0--- 12
Orlando Ortez--- 42-- 0--- 0



Update : I tried Sumifs (Sum range, TK2 array, "name", TK1 array, "<>name"), It didn't work.

[DBY]

Hello
Not sure if this is correct but these formulas match your manual values. For TK2:

Please Login or Register  to view this content.

and TK3:

Please Login or Register  to view this content.

DBY