need to average based on criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drd - 30 May 2008 18:45 GMT

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

Reply to this Message

Bob Phillips - 30 May 2008 18:48 GMT

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

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

Signature

HTH

Bob

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

> 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

Reply to this Message

drd - 30 May 2008 22:17 GMT

Thank you. It worked great:)

> =AVERAGE(IF((B2:B20={"A","AC"}),U2:U20))
>
[quoted text clipped - 7 lines]
> > I have Excel 2003
> > Thx

Reply to this Message