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?
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?
Why not do a SUMIF( ) divided by COUNTIF( ) ?
Pete
=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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks