Forum Discussion
Average of first n numbers ignoring blank cells
I want to average the first n numbers in a row and have the blank cells ignored. e.g on the attached file I want to average Kate's first 6 numbers and have the 7th number, 57.08, not counted, but I w...
Hi
Something like this.
=AVERAGE(B3:INDEX(3:3,AGGREGATE(15,6,COLUMN(B3:M3)/(B3:M3>0),6)))
