But in practice, it did not. Are there special cases when it works and
doesn't work?

"Mike H" wrote:

hi,

Excel ignores blank cells in an average formula so this works

=AVERAGE(A3,D3,G3,J3)

Mike

"JJ" wrote:

I want to calculate the average of non-adjacent cells (ie "=average(A3, D3,
G3, J3)"). In some cases there are blank cells in the set. How do I prevent
these blank cells from being counted as zeros? I do not want them included
in the average. I have only found instructions on how to do this when the
set is continuous (ie "=average(A1:A10)").

Thanks for your help!