Just add the average to a separate column, =AVERAGE(B2:M2), and then filter
that column by your criteria

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"vijaydsk1970" wrote in message
...
I have an excel sheet contains all the customers in once column "a" and
their
monthly sales in column "b,c,d,e,f,g,h,i,j,k,l,m" and average in "n".
I want to filter all the customers whose average is 0 and less than 50
sales and another condition is 50 and less than 100.
Kindly advise me any formula, so that i can filter all the above said
customers and put them in an other sheet.

Thanks in advance.