Hi , I`m currently using the following formula fine:

=AVERAGE(IF(($H$10:$H$89=0)*($N$10:$N$89="W")*($AB $10:$AB$89-10),$AB$10:$AB$89))

This then selects only the values in the cells in collumn AB that satisfy
the other criteria.
Right, now I want to say do a similar search and average on the cells that
match a specified conditions but in column N10:N89, I want to say "IS NOT
EQUAL TO "Dog"" or whatever the text I want to be not included in the
average.

Sorry my description is probably rubbish.
Hope someone gets the idea and can solve it.
Thanks.
RR1