Averageifs named ranges

[Tesnobay]

=averageifs(aprildata,maydata,junedata,"<>0")

Why doesn't this work?

 

[Tesnobay]

[TABLE="width: 258"]
<colgroup><col width="72" style="width: 54pt;"><col width="52" style="width: 39pt;"><col width="47" span="2" style="width: 35pt;"><col width="40" style="width: 30pt;"></colgroup><tbody>[TR]
[TD="class: xl66, width: 72, bgcolor: yellow"]April[/TD]
[TD="class: xl64, width: 52, align: right"]4/2[/TD]
[TD="class: xl64, width: 47, align: right"]4/3[/TD]
[TD="class: xl64, width: 47, align: right"]4/4[/TD]
[TD="class: xl64, width: 40, align: right"]4/5[/TD]
[/TR]
[TR]
[TD="class: xl63"]Day[/TD]
[TD="class: xl65, align: center"]Mon[/TD]
[TD="class: xl65, align: center"]Tue[/TD]
[TD="class: xl65, align: center"]Wed[/TD]
[TD="class: xl65, align: center"]Thu[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]AM[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC7CE]#FFC7CE[/URL] , align: right"]242[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC7CE]#FFC7CE[/URL] , align: right"]209[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFEB9C]#FFEB9C[/URL] , align: right"]188[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFEB9C]#FFEB9C[/URL] , align: right"]198[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]PM[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C6EFCE]#C6EFCE[/URL] , align: right"]151[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C6EFCE]#C6EFCE[/URL] , align: right"]129[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C6EFCE]#C6EFCE[/URL] , align: right"]153[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFEB9C]#FFEB9C[/URL] , align: right"]182[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]Evening[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC7CE]#FFC7CE[/URL] , align: right"]208[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFEB9C]#FFEB9C[/URL] , align: right"]167[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC7CE]#FFC7CE[/URL] , align: right"]243[/TD]
[TD="class: xl63, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFEB9C]#FFEB9C[/URL] , align: right"]177
[/TD]
[/TR]
</tbody>[/TABLE]
I expanded to B2 to show the whole lay out

 

[Aladin Akyurek]

Thanks for the sample.

Try:

=SUM(AprilData,MayData,JunData)/INDEX(FREQUENCY((AprilData,MayData,JunData),0),2)

 

[Tesnobay]

Thank you!

 

[Aladin Akyurek]

Thank you!

You are welcome.