how to code a sum with only values above certain value?

[#1]

Hello,

   I been trying for a while now and cant find a way to discriminate certain values of a table. To make it short, I want the sells average of products with a sell above $50,000. Example:

Products	Sells
Product 1	10,000
Product 2	60,000
Product 3	70,500
Product 4	45,000
Product 5	50,200
Expected result	60,233

This result come from (Product 2+Product 3+Product 5)/3

Thank you in advance.

[swuehl · Accepted solution]

Try something like this in a text box:

=Avg( {<ProductField = {"=sum(SellingField)>50000"}>} Aggr( Sum(SellingField), ProductField ))

Replace ProductField and SellingField with your appropriate field names.

[#3]

Thanks a lot!!!! it worked perfectly