Hi everyone,

Does anyone know how to solve the issue that I'm facing?
I basically need to provide the average for M01 M02 M03 for my Q1, but some
cells do not contain any data are empty =""

My formula is:
=IF(ISNA(+IF(O49="",AVERAGE(VLOOKUP($D$22,'sheet1' !$A$4:$BM$1000,26,FALSE),VLOOKUP($D$22,'sheet1'!$A $4:$BM$1000,27,FALSE),VLOOKUP($D$22,'sheet1'!$A$4: $BM$1000,28,FALSE)),O49)),"",(+IF(O49="",AVERAGE(V LOOKUP($D$22,'sheet1'!$A$4:$BM$1000,26,FALSE),VLOO KUP($D$22,'sheet1'!$A$4:$BM$1000,27,FALSE),VLOOKUP ($D$22,'sheet1'!$A$4:$BM$1000,28,FALSE)),O49)))

But this one is taking into account the empty and counting them as zero :(
Could anyone point out some solution?

Thanks!