Average if

[Thiem]

I want to average a colum of info, but I have multiple product in this colum. I want do a basic sumif, but average figures. Is this possible?

[Pete]

Why not do a SUMIF( ) divided by COUNTIF( ) ?

Pete

[Bob Phillips]

=AVERAGE(IF(rng="value",rng))

which is an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Thiem" <[email protected]> wrote in
message news:[email protected]...
>
> I want to average a colum of info, but I have multiple product in this
> colum. I want do a basic sumif, but average figures. Is this possible?
>
>
> --
> Thiem
> ------------------------------------------------------------------------
> Thiem's Profile:
http://www.excelforum.com/member.php...o&userid=27474
> View this thread: http://www.excelforum.com/showthread...hreadid=495132
>