AVERAGE ignores empty cells. To exclude numeric 0:

=AVERAGE(IF(A3,A3,{""}),IF(D3,D3,{""}),IF(G3,G3,{" "}),IF(J3,J3,{""}))

--
Biff
Microsoft Excel MVP


"JJ" wrote in message
...
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!