Google Sheets: Average but without using range

Hello! Just want to ask if there is an easy way for me to find the average but not using range since the values are placed in different cells?

Here the cells and the formula that I'm using to get the average (J28+O28+T28+Y28+AD28+AI28+AN28+AS28+AX28)/8

It is working, yes. But the problem is that there is a cell that the value may be empty. For example, all of it has a value except for AS28 & AX28, so the denominator should be 6 and not 8.

Is there a way for me to easily do this? Thanks!

Try each of the following

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.