something like

=AVERAGE(IF(B2:B102,B2:B10))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

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


"davidad" wrote in message
...
Does anybody have an "AVERAGEIF" function they could pass
on to me? I'm new to programming and have failed miserably
trying to write it. Any help would be great. Thanks.