I an trying to filter a table that contains house prices. I would like to
filter to show the records where the list price is less than the average list
price of all records.

I am using the formula =ListPriceAVERAGE(C:C) but I keep getting a #DIV/0!
error even if I specify the actually range of my data e.g.
=ListPriceAVERAGE(C2:C50).

Any ideas?

Thank you