Hi All!

I am working on a spreadsheet with multiple columns of information. In one area I need to get an average of percentages, but there are some wrinkles:
1. The cells are not adjacent to each other
2. Some cells have a 0 value
3. Some cells have a -1 value

I want to get the average of the 6 non-adjacent cells excluding 0 & -1 values

I came up with the following formula, but there has got to be a better way.
Formula: copy to clipboard 
=(SUMIF(B3,">0")+SUMIF(D3,">0")+SUMIF(F3,">0")+SUMIF(H3,">0")+SUMIF(J3,">0")+SUMIF(L3,">0"))/(COUNTIF(B3,">0")+COUNTIF(D3,">0")+COUNTIF(F3,">0")+COUNTIF(H3,">0")+COUNTIF(J3,">0")+COUNTIF(L3,">0"))


There are between 8 and 10 columns between each of the 6 values I am trying to average, below is a simple picture. I can't seem to use AVERAGEIF since that needs a continuous range, unless I am missing some?

Please let me know if there is a easier, better way to do this and thank you very much for any help you can provide!
Doug

Screenshot 2021-04-30 152529.png