Your original question and each comment all pose different questions.
In the original question let those values reside in Row 1. Then
=AVERAGEIF(A1:F1,">0") = 3
In your first comment you must seperate the individual cells with a tilde
In second comment, using ROWS or COLUMNS (EVEN or ODD) thus skipping every other row or column, you must enter the following function as an array (click on Array in Function Wizard OR enter function in cell and complete with
Function to enter:
At end of entry then
Enter and the function will look like this:
This will look at only ODD columns ( A, C, E, etc.) You can also change to ISEVEN for even columns (B,D,F etc.)
ROWS works in the same fashion but remember the ranges change - A1:A20 for example.
Edit: changed “formula” to “function”.