Code or formula help for the LinEst function

So I have some spreadsheets made to do some caclulations on data I get from a possible set of 20 test runs. EX:
Run Y X
1 2 4.78
.....
20 6.23 5.09

The worksheet works fine as long as there are the complete set of 20 runs. My problem is that on a given day I may do a few less runs and so I want a formula or VBA to be able to only account for the runs that I do on that day. As you can see from my attached worksheet the first page titled LINEAR works fine and doesn't use the LinEst function. So delete the last couple of runs (blue numbers) and press update numbers on the LINEAR worksheet and go to the subsequent worksheets (POLYNOMIAL, LOGARITHMIC, EXPONENTIAL, POWER) and you can see at the top of the pages the trendline coefficients that are highlighted that give me a #VALUE error when there are fewer runs. Any kind of help would be greatly appreciated (just a better formula or VBA)

Try this formula in POLYNOMIAL sheet E3

=INDEX(LINEST(N(OFFSET(C7:C26,SMALL(IF(ISNUMBER(C7:C26),ROW(C7:C26)-ROW(C7)),ROW(INDIRECT("1:"&COUNT(C7:C26)))),,1)),N(OFFSET(B7:B26, SMALL(IF(ISNUMBER(B7:B26),ROW(B7:B26)-ROW(B7)),ROW(INDIRECT("1:"&COUNT(B7:B26)))),,1))^{1,2}),1)

Needs to be confirmed with CTRL+SHIFT+ENTER

Your other LINEST functions can be modified in a similar way

This follows the suggestion here from Microsoft MVP Andrew Poulsom

Ok I have the POLYNOMIAL sheet figured out and for logarithmic I am entering this but cant seem to come up with the right value

=INDEX(LINEST(N(OFFSET(D7:D26,SMALL(IF(ISNUMBER(D7:D26),ROW(D7:D26)-ROW(D7)),ROW(INDIRECT("1:"&COUNT(D7:D26)))),,1)),LN(N(OFFSET(B7:B26, SMALL(IF(ISNUMBER(B7:B26),ROW(B7:B26)-ROW(B7)),ROW(INDIRECT("1:"&COUNT(B7:B26)))),,1)))^{1,2}),1)

I added the LN function to where I thought is the right place but I am not getting the right value somehow