=AVERAGE(IF(A2:A20="Nick",B2:B20))

as an array formula, so commit with Ctrl-Shift-Enter


--

HTH

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


"Nancy" wrote in message
...
I have the following:
Column A has names, column B has numbers.
I want to average the numbers in column B, only if the name is "Nick".

Thanks for any help you can give!