Hi
try the array formula
=AVERAGE(IF(C4:C362="M.2FL",H4:H362))

comitted with CTRL+SHIFT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany
"LWS" schrieb im Newsbeitrag
...
I need to create a formula that will average numbers in one column, based
on
data in another column.
example:
AVERAGE H4:H362 IF C4:C362=M.2FL
or
AVERAGE H4:H362 IF C4:C362=M.MED

Thanks for your help