Data analysis across multiple worksheets but omitting zero values

[seleseped]

Hello,
I have 23 worksheets (named 1, 2, . . . , 23) all based in the same template. In a summary worksheet, I'd like to do some summary analyses, e.g., medians of data from all of the 23 worksheets. To find the median of the values in column D of all of the sheets, I have found this array formula to work:
{=MEDIAN('1:23'!D3:D50)}.

I now would like to calculate the median of that same number set but with zero values omitted. I tried:
{=MEDIAN(if('1:23'!D3:D50<>0,'1:23'!D3:D50)} but got a non-helpful #REF! message.

Does anybody have any ideas that would help?

Thank you in advance for your time and expertise.
Shelley

 

[Special-K99]

Seems to work with 3d reference without the IF condition, or with one Sheet with arrayed IF condition
but not with 3d reference and arrayed IF condition

 

[Special-K99]

Is this of any use?

http://www.mrexcel.com/forum/excel-questions/260914-3d-array-formula-possible.html

 

[seleseped]

Is this of any use?

http://www.mrexcel.com/forum/excel-questions/260914-3d-array-formula-possible.html

Thanks for the suggestion. I tried it but couldn't get it to work. The 'IF' statement is what hangs things up. Maybe it's not possible. I finally just copied the worksheets, deleted the zero values and went from there.