I have an array formula that I want to work over multiple sheets but the following formula doesn't work. Am I misstating how excel looks at multiple sheets? I want to look down the same column (A5 to A80) across multiple sheets (sheet names are 1,2,3,4,5,6,7,8,9,10,11,12,13). If the number is 99 in A5 to A80, sum H5:H80 across the 13 sheets and give me the result. Here's the incorrect array formula:
{=SUM(IF('1:13'!A5:A80=99,'1:13'!H5:H80,""))}
{=SUM(IF('1:13'!A5:A80=99,'1:13'!H5:H80,""))}