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

[nobodyukno]

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.

[mcmahobt]

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

Please Login or Register  to view this content.

[nobodyukno]

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

Please Login or Register  to view this content.

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

[mcmahobt]

Try this, entered with CSE:

Please Login or Register  to view this content.

[nobodyukno]

Try this, entered with CSE:

Please Login or Register  to view this content.

Nailed it. Greatly appreciate the help!