Try:

=AVERAGE(IF(($A$1:$A$100="R1")*($B$1:$B$100="Mon") *($C$1:$C$100=1),ISNUMBER($D$1:$D$100)),$D$1:$D$10 0)

"Neil" wrote:

Hi

I have four columns of data A,B,C and D. I would like to get the average
from the results in column D. But only when it matches certain criteria in
A,B and C.

I put
{=AVERAGE(IF(($A$1:$A$100="R1")*($B$1:$B$100="Mon" )*($C$1:$C$100=1),$D$1:$D$100))}

This works ok but sometimes when i have this data in there for info in other
columns such as E,F. The D will be blank but this will affect the average.
Can i add something to ignore the blanks cells.

Many thanks