Hi
this is an array formula. See:
http://www.cpearson.com/excel/array.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"LWS" schrieb im Newsbeitrag
...
WOW !!!! it works !!! I have been fighting with this, and other
variations,
for weeks, several people in my office have also been fighting it. Thank
you
so much !!!

Frank, one question, I have never used the "comitted with
CTRL+SHIFT+ENTER"
before, how does that work, and how can I apply it with other formulas?
Thank
you very much.
Lisa

"Frank Kabel" wrote:

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