Adjust this formula to count the first 3 columns rather than the last 3?

Ok, so I found this formula online, and have adjusted it to fit my needs and it works generally.

=AVERAGE(INDEX(L6:FZ6,LARGE(IF(L6:FZ6<>"",COLUMN(L6:FZ6)-COLUMN(L6)+1),3)):FZ6)

However, the formula calculates the average of the LAST 3 non-blank columns. I would like the formula to calculate the average of the FIRST 3 non-blank columns starting with column L. Any ideas?

Thank you all in advance.

Originally Posted by mcmahobt

Without seeing how your data is setup, what does this return?

=AVERAGE(INDEX(L6:FZ6,SMALL(IF(L6:FZ6<>"",COLUMN(L6:FZ6)-COLUMN(L6)+1),3)):FZ6)

It seems like it is taking the average of the LAST 4 non-blank cells for some reason?

Originally Posted by mcmahobt

Try this, entered with CSE:

=AVERAGE(OFFSET($L$6,,,,SMALL(IF($L$6:$FZ$6<>"",COLUMN($L$6:$FZ$6)-COLUMN($L$6)+1),3)))

Nailed it. Greatly appreciate the help!