This expression should get you there
In say, F2, array-entered,
ie confirm the formula by pressing CTRL+SHIFT+ENTER:
=AVERAGE(IF((A2:A10="P1")*(B2:B10="Red")*(D2:D10=2 0),E2:E10))
Adjust the ranges to suit

Above assumes that col D contains real nums.
If its text nums, change it to: D2:D10="20"
(put double quotes around the 20)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"WildWill" wrote:
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.