One way, put all the sheet names (not just first and last) in a range, then
define a name like MyLst or use the range itself

=SUMPRODUCT(SUMIF(INDIRECT("'"&MyLst&"'!H13"),"0" ,INDIRECT("'"&MyLst&"'!F13")))

if the sheet names are in Z1:Z20 you can select that range and type in a
name in the namebox or use the range itself

=SUMPRODUCT(SUMIF(INDIRECT("'"&Z1:Z20&"'!H13"),"0 ",INDIRECT("'"&Z1:Z20&"'!F13")))

Regards,

Peo Sjoblom

"Jet" wrote:

Trying to sum all F13 cells on multiple worksheets where H13 is 0
Tried =IF('Store # 85:[Store # (35)]Store # (35)'!H130,SUM('Store #
85:[Store # (35)]Store # (35)'!F13)) and getting a #REF error