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?
Thanks!
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!