need to average based on criteria
 

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

need to average based on criteria
 

=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" wrote in message
...
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

need to average based on criteria
 

Thank you. It worked great:)

"Bob Phillips" wrote:

=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" wrote in message
...
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