SUMIF with 2 conditions

[fable]

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

 

[Robert Mika]

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

Excel 2007/2010

=SUMPRODUCT(SUMIFS(INDIRECT("'"&SheetList&"'!F:F"),INDIRECT("'"&SheetList&"'!$B:$B"),B5,INDIRECT("'"&SheetList&"'!$C:$C"),$B5))

 

[fable]

Thanks very much!

You're really very good at this, arent you? haha! Thanks again!

 

[Robert Mika]

Thanks very much!

You're really very good at this, arent you? haha! Thanks again!

You are welcome.Thanks for feedback.