Dear Forum,

I want to use the AVERAGEIF function in order to take the average of a column. The criteria in the function is that only the values in the column should be taken if they are below a certain value. If this value is known I could simply write something like "<4.023". However, this value differs for every column. Therefore I want to refer to a cell in the criteria box. So lets say I calculated the 4.023 of the previous example in a different cell (A2). Now, when I want to put it in the criteria it does not work. I have tried the following in the criteria: "<"A2 "<A2" <A2 . Is it possible to state a criteria the says the value is lower than a selected cell? I really hope so otherwise I will have to manually input all the values in the formula bar which will take me a lot of time.

Thank you in advance!