vlookup cells thAT are `NOT EQUAL` to a value / text

[Romileyrunner1]

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

 

[Sam Wilson]

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

means, if Hx is 0 and Nx is not Dog and ABx is more than -10, include the
number in ABx in the average.

 

[Ashish Mathur]

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Romileyrunner1]

Thanks Ashish.
Works great!

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Romileyrunner1]

Great work SAM
Works really well.
Clever chap. Thanks