Hi ALL

I'm trying to find the average of a column (let's say column C cells C90:C96)

However, column A needs to contain a text value (let's say "FAB" A90:A96)

AND

Column B needs to contain a numeric value (for each occurance of "FAB").

My current formula doesn't sort out the column B issue and if a column doesn't contain FAB it displays a #DIV/0!

=AVERAGE(IF(A90:A96="FSM",C90:C96,"0"))

Any help would be greatly appreciated.

Thanks :D