excel - Formula over multiple sheets with condition -

excel - Formula over multiple sheets with condition -

i have 5 sheets named sheet1, sheet2, ..., sheet5. want sum values cell a2 cell a10 on these sheets. want include sheet in sum if value in cell a1 equal 3. formula require accomplish this?

try this:

=sum(if(n(indirect("'sheet"&{1,2,3,4,5}&"'!a1"))=3,sumif(indirect("'sheet"&{1,2,3,4,5}&"'!a2:a10"),">0")))

regards

excel