SUMPRODUCT #VALUE! ERROR

[worlockb]

Hello,

I need some assistance in a formula and I keep getting the #VALUE! error. I am assuming it is because I am joining text and numbers. But I may not even be using the correct formula.

=SUMPRODUCT(--(Group&TimeOff=$C$2&F1,INDEX(TimeOff,,MATCH($D$5,'Time Off'!$F$3,0))))

What I am trying to do is the following:
On the "Planner" tab, If C2 (Phones) and F1 (The Date) match Column A and Column G on the Time Off tab, i want the total sum of hours lost from Column F.

Can anyone help?

Resource Example.xlsx

drive.google.com

Thanks!

 

[KOKOSEK]

On planner tab, into F5:

=SUMIFS('Time Off'!$F:$F,'Time Off'!$G:$G,Planner!$C$2,'Time Off'!$A:$A,Planner!F$1)

and drag it right.