Ignore me. Apparently I missed a set of brackets, which I'm sure I had put in before and hadn't worked.
Move along
Ignore me. Apparently I missed a set of brackets, which I'm sure I had put in before and hadn't worked.
Move along
Last edited by Sinnie; 10-27-2015 at 12:51 PM.
It's missing a set of ()
Try
=SUMPRODUCT((INDIRECT("'"&G2&"'!G4:G1273")=1)*(INDIRECT("'"&G2&"'!D4:D1273")=C2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks