I have a worksheet that lists current data and YTD data.

A1 current data

A2 YTD data

A3 current data

A4 YTD data

A5 current data

A6 YTD data

A7 current data

A8 YTD data

A9 current data

A10 YTD data

A11 current data

A12 YTD data

A13 current data

A14 YTD data

A15 current data

A16 YTD data

I would like to find the average of these numbers but with only those numbers that are not 0. I have created this formula but excel is not allowing me to select more then 4 cells.

the formula that I have is in A25 to find the average of just the current data cells is =AVERAGE(IF(A1,A3,A5,A7,A9,A11,A13,A15<>0, A1,A3,A5,A7,A9,A11,A13,A15,"")) but it is telling me there are to many arguments in the function.....

how do I make this formula work.....

Please HELP!