Hello!



I'm trying to modify a SumIf to sum across multiple sheets (they are actually workbooks though). Below is the formula I have right now however it's not working. Example A and Example B are their own individual sheets in their own workbooks.

=sumproduct(SUMIF(Indirect("'"[Example A.xlsx]Schedule&[Example B.xlsx]Schedule"'!$U$13:$U$17"),$B40,Indirect("'"[Example A.xlsx]Schedule&[Example B.xlsx]Schedule"'!$V$13:$V$17)))


The goal here is to sum V13:V17 in Example A when criteria in B40 is met in range U13:U17 and to sum S13:S17 in Example B when criteria in B40 is met in range R13:R17. Obviously, I'm missing the ranges from Example B, but I was hitting my head against a wall and decided to come here for help.

I tried checking before and that's how I came across the sumproduct example but couldn't get it to work properly.

Any help is greatly appreciated! I've also posted a previous thread at this link:
https://www.mrexcel.com/forum/excel-...ets-books.html

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?

Attached Images

error.PNG (11.3 KB, 14 views)