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

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