Average Multiple Pages

[LadyDi]

Can the AverageIf formula be used as an aggregate formula?

I'm trying to get an overall average from 5 tabs on a workbook. I tried using =AVERAGEIF('MON:FRI'!F6:F615, ">0"). Unfortunately, this returns a "Value" error. Is there a way to get this to work?

 

[arnelgp]

you can use SUM(range1, range2, rangeN)/Count(range1, range2, rangeN)