Based on furthering this I need to now make it dependant upon two cells, my formula is
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!$B:$B"),$B5,INDIRECT("'"&SheetList&"'!F:F")))
I've tried
=SUMPRODUCT(SUMIF(AND(INDIRECT("'"&SheetList&"'!$B:$B"),INDIRECT("'"&SheetList&"'!$C:$C")),$B5,INDIRECT("'"&SheetList&"'!F:F")))
and I can't quite get it to work, probably something to do with the fact that the and section's product comes out as false...
Please advise?
Thanks!
~F
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!$B:$B"),$B5,INDIRECT("'"&SheetList&"'!F:F")))
I've tried
=SUMPRODUCT(SUMIF(AND(INDIRECT("'"&SheetList&"'!$B:$B"),INDIRECT("'"&SheetList&"'!$C:$C")),$B5,INDIRECT("'"&SheetList&"'!F:F")))
and I can't quite get it to work, probably something to do with the fact that the and section's product comes out as false...
Please advise?
Thanks!
~F