averageif with critera being a reference cell that contains a formula returns div/o error

It works if I type the value of the cell in like this:
=AVERAGEIF(H2:H21,"<37.62")
but if I pick the cell as the criteria like this:
=AVERAGEIF(H2:H21,"<H26")
then it returns #DIV/0!
This is what is in cell H26:
=H25*1.2
Help please and thanks!

That happens because you are dividing by a text "<H26" which cannot be done. a small change will solve your problem
you have to concatenate the mathematical characters (< > =) and the actual cell holding the value to for the criterium.. that is done with the & sign..

so try:

Formula:

Please Login or Register  to view this content.

This way excel regcognizes H26 as a cellreference and not as a text.