Average the last 10 cells of a dynamic column but ignore blank cells & 0

I have a spreadsheet that will dynamically be changing in the number of rows each column has. Each column may have random blanks or 0s within it. I want to average the last 10 cells in the column. If the columns last 10 rows have 5 values and 5 blanks, I'd like to simply average the 5 values and ignore the blanks. Please let me know if you need any clarification on what I am trying to do. Thanks in advance

Thank you for this. Making progress, but having 1 issue. I've tried posting this earlier but doesn't seem to be posting so apologies if this is repetitive.

I get a VALUE error in the columns where the last row of the table is blank. I am referencing a pivot table FYI.

For example:

100 200
BLANK 300
200 400
300 BLANK

The 2nd column would give me a VALUE error. Thanks!

Either...

=AVERAGE(OFFSET(INDEX(A:A,MATCH(9.99999999999999E+307,A:A)),0,0,-10))

Or...

=AVERAGE(OFFSET(INDEX(A:A,MATCH(9.99999999999999E+307,A:A)),0,0,-MIN(10,COUNT(A:A)))