averaging on an "if" or "sumproduct"

N

Nancy

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!
 
S

SteveG

Nancy,

Type in this formula where you want the result.

=AVERAGE(IF(A2:A8="Nick",B2:B8,""))

This is an array formula so commit with Ctrl-Shift-Enter which will
result in

{=AVERAGE(IF(A2:A8="Nick",B2:B8,""))}



Cheers,

Steve
 
B

Bob Phillips

=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)
 
Top