How can I average non-adjacent cells in excel, excluding zero?

I’m working on a spreadsheet in Excel 2007 that will record daily information. There are two columns of figures for each day of the week. I want to average columns (B,D,F,H,J,L,N) at the end of the week. I’ve googled this and tried a few things already.

I used the formula =SUM(B2,D2,F2,H2,J2,L2,N2)/COUNTIF(B2:N2,”>0”), and got an error message- something about there being too many cells?

I tried an array formula, =AVERAGE(IF(B2:N2=0,FALSE,B2:N2)), which wasn’t right for this because it included all the cells in the range. I only want these alternating cells.

The reason for excluding zeros is that I will be entering this information daily throughout the week. I want my averages to be as accurate on Wendsday, when the chart is half full, as they are on Sunday.