I have a question about an average formula.
Below is the forumla I am using:
=IFERROR(AVERAGEIFS('MONTH TO DATE RAW DATA'!E:E,'MONTH TO DATE RAW DATA'!C:C,A30,'MONTH TO DATE RAW DATA'!AJ:AJ,"NO"),"0")
I am having it look at raw data on sheet 'MONTH TO DATE RAW DATA' and if comes across any...