Hi everyone!
I'm trying to SUM the values in L2:L639 where there are two matches: A26 on the Unique Projects worksheet matches values from F2:F639 on the Not Uploaded worksheet AND where B26 on the Unique Projects worksheet matches values from K2:K639 on the Not Uploaded worksheet.
Getting #VALUE! pus the formula is automatically filling down 639 rows, which I don't understand. There are definitely matches that should be summed. Where did I go wrong?
Thanks
I'm trying to SUM the values in L2:L639 where there are two matches: A26 on the Unique Projects worksheet matches values from F2:F639 on the Not Uploaded worksheet AND where B26 on the Unique Projects worksheet matches values from K2:K639 on the Not Uploaded worksheet.
Excel Formula:
=SUMIFS('Not Uploaded'!$L$2:L$639,'Unique Projects'!$A26,'Not Uploaded'!$F$2:$F$639,'Unique Projects'!B26,'Not Uploaded'!$K$2:$K$639)
Getting #VALUE! pus the formula is automatically filling down 639 rows, which I don't understand. There are definitely matches that should be summed. Where did I go wrong?
Thanks