SumIf across sheets

Wolfgang17 said:

I am trying to sum a range of cells across two sheets. The sheet names are "Dec 19 2010" and "Dec 26 2010". I would like to sum the total of range J10:J30 on both sheets if the criteria of "6-Fixed OT", which is held in cell T3 on my "Summary" sheet, is selected from range K10:K30 on both sheets.

I've tried the formula below with many similiar variations with no success. Any help would be appreciated.

=SUMPRODUCT(SUMIF(INDIRECT(""& 'Dec 19 2010 : Dec 26 2010'!K10:K30"),Summary!T3,INDIRECT(""&' Dec 19 2010 : Dec 26 2010'!"J10:J30)

Thanks

Click to expand...

Wolfgang17 said:

I keep getting a "Your Formula is missing a Parenthesis...." error. I can't figure out where though.
=SUMPRODUCT(SUMIF(INDIRECT("'"&Cheque1&"'!K10:K30"),Summary!T3,INDIRECT("'"&Cheque1&"'!J10:J30")

Thanks

Click to expand...

=SUMPRODUCT(
   SUMIF(INDIRECT("'"&Cheque1&"'!K10:K30"),
             Summary!T3,
             INDIRECT("'"&Cheque1&"'!J10:J30"))

Wolfgang17 said:

Thank You that worked.
I was sure I tried everything. Sorry for the trouble.

Click to expand...

Wolfgang17 said:

I am trying to get this to work. I am not sure it's even possible to sum multiple ranges like this. Any help would be appreciated.

=SUMPRODUCT(SUMIF(INDIRECT("'"&Cheque1&"'!c10:c30"),Summary!p4,INDIRECT("'"&Cheque1&"'!J10:J30,H10:H30,M10:M30")))

Thanks

Click to expand...