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