Averaging cells

[PaulJ]

I have 6 cells I want average, Y13, Y15, Y17, Y19, Y21 & Y23. There are no used cells between these cells. I want the answer in Cell Z23. This number (Z23) is used for other calcs.

BUT, I want a cell with no entry to be ignored and not be a zero to be averaged. So if Y17 had no entry, the sum is divided by 5 not 6.

Thanks in anticipation.

 

[onlyadrafter]

Hello,

=AVERAGE(Y13:Y23) ignores blank cells, but doesn't ignore 0 values.

=SUM(Y13:Y23)/COUNTIF(Y13:Y23,">0") will ignore 0 values.

This assumes there is no data inbetween cells as you described.

 

[PaulJ]

Thanks, works great.