Average IF + advanced filter ->fails

[TomZ]

Hi,

I made a formula in excel
{AVERAGE(IF(E2:E114="diesel",C2:C114,""))}

it works fine.

The problem is, if I want to use this as a criteria for advanced filter of my db.
It looks like this:
{=C100<PRŮMĚR(KDYŽ(E2:E114="benzín",C2:C114,""))}
The problem is, that it works only for 1st line of the db. I think, that for other lines it is not possible to "transform" to {bla bla} look..

Is any way how to use a result of a nut as a criteria for filter?

Thx

[TomZ]

I found out, that i can avoid this by using either SUMIF(....)/COUNTIF(...) or DAVERAGE(). On the other side, both of these ways are not the best solutions...