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?
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?