Assuming a formula in Cell B98
=IF(ISERROR(AVERAGEIF('MYTab'!H1:H150,">0")),0,AVERAGEIF('MYTab'!H1:H150,"> 0"))
where MyTab is a tab name, but Cell A98 has the text "MyTab". How would I use Indirect() to reference cell A98 in the formula in B98. I have tried stuff like
=IF(ISERROR(AVERAGEIF(Indirect(&"A98"&!H1:H150),">0")),0,AVERAGEIF(Indirect ("&A98&"!H1:H150),">0"))
but appear to be syntactically challenged.
Appreciate any pointers.