AN improvement

=AVERAGE(IF(N(INDIRECT({"A1","A4","A6","A8"}))0,N (INDIRECT({"A1","A4","A6",
"A8"}))))

BTW, these are array formulae, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Larry4500" wrote in message
oups.com...
Last last question: how do you use this function and reference two or
more groups of noncontiguous cells? So, first I'm calculating the
averages of the subgroups and then I want the average of the larger
groups as a whole. Thank you.