need to average based on criteria

[drd]

In column B there are letters "A,AC,P,PB,S".
In column U there are numbers.
need formula that searches column B for the letters "A" and "AC" then goes
to column U and averages those numbers that meet the criteria.
I have Excel 2003
Thx

 

[Bob Phillips]

=AVERAGE(IF((B2:B20={"A","AC"}),U2:U20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[drd]

Thank you. It worked great

=AVERAGE(IF((B2:B20={"A","AC"}),U2:U20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)