Try this array formula** :

=AVERAGE(IF((A1:A10="P1")*(B1:B10="red")*(D1:D10=2 0),E1:E10))

Better to use cells to hold the criteria:

G1 = P1
H1 = red
I1 = 20

=AVERAGE(IF((A1:A10=G1)*(B1:B10=H1)*(D1:D10=I1),E1 :E10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"WildWill" wrote in message
...
I have 5 columns of data and need a a formula that will allow me to
calculate
the following:

Average the values of column E for all instances where column A = "P1" and
column B = "Red" and Column D = "20". I.e. the average will only be
calculated for the lines in column E where the above conditions have been
met
in the other columns, as mentioned.