"Knox" wrote:
{=AVERAGE(IF(AND(B2:B13241=1,D2:D13241=2),N2:N1324 1,""))}
You could also try it slightly amended like this, array-entered with CSE*:
=AVERAGE(IF((B2:B13241=1)*(D2:D13241=2),N2:N13241) )
*CSE = Press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---