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

  • Thread starter Thread starter Romileyrunner1
  • Start date Start date
R

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
 
=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.
 
Back
Top