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)
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!
Any help would be greatly appreciated.