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...