Average if

T

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?
 
B

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)
 
Top