I use this formula to find a minimum value in a column of numbers: =MAXIFS(BG7:BG10000;BG7:BG10000;"<1.04") giving the correct answer in this case 1.03822

So works fine - but I would like to be able to change the "<1.04" criteria using an external cell.....

I have tried this: =MINIFS(BG7:BG10000;BG7:BG10000;INDIRECT("">"&A2&""")) but I just get a clean 0 as answer (A2 cell contains the 1.04 value).

Could you pls advice?