0
I've been working on this for a few hours, but for the life of me I can't quite figure out why its behaving this way.
I'm using the following formula:
=SUMPRODUCT(SUMIF(INDIRECT(Sheets&"!D:D"),A1,INDIRECT(Sheets&"!E:E")))
I also created a named range
={"One";"Two"}
(both things are in the Totals sheet).
But for some reason, its only adding the numbers in the first sheet.
see Totals!B1
This number should be 33, not 11. It should be adding the totals from ONE (sheet) and TWO (sheet).
https://docs.google.com/spreadsheets/d/1pV2bEY6AcZADtUqnmGtQUGPpJ8Ir-p-MbMyvJ5dclW0/edit?usp=sharing
Any thoughts?