|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
vlookup cells thAT are `NOT EQUAL` to a value / text
Thanks Ashish.
Works great!
"Ashish Mathur" wrote:
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" wrote in message
...
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
|