sumif across multiple sheets

[colinheslop1984]

I have sheets named Jun 2012, Jul 2012...to Mar 2015

I want to sum

(across all sheets)​

s:s if r:r =q2

I have seen this formula =SUMPRODUCT(SUMIF(INDIRECT("'"&Z1:Z212&"'!B3"),99,INDIRECT("'"&Z1:Z212&"'!G3")))

But cant seem to tailor it to my needs

I have a list on the sheets running from p336, q2 is the criteria

Any ideas?

 

[Domenic]

Try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&$P$3:$P$36&"'!R:R"),Q2,INDIRECT("'"&$P$3:$P$36&"'!S:S")))

Hope this helps!

 

[colinheslop1984]

Try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&$P$3:$P$36&"'!R:R"),Q2,INDIRECT("'"&$P$3:$P$36&"'!S:S")))

Hope this helps!

I just get an error #REF !

 

[Domenic]

The formula will return #REF ! when one or more sheets listed in P3:P36 do not exist.