I currently am getting the attached error message for the below formula:
=sumproduct(SUMIF(Indirect("[Example A.xlsx]Schedule!$U$13:$U$17&[Example B.xlsx]Schedule!$R$13:$R$17"),$B40,Indirect("[Example A.xlsx]Schedule!$V$13:$V$17&[Example B.xlsx]Schedule!$S$13:$S$17)))
Thoughts?
|