New Contributor


I am using the following function MINIFS with the prefix _xlfn to find the minimum value metting 2 criteria (=+_xlfn.MINIFS(E:E;D:D;D2;C:C;C2)), but I keep #NAME? error (I have the updated version of 365). Any suggestions?

2 Replies
best response confirmed by Sergei Baklan (MVP)

@Jacqui2312 MINIFS is supported by Excel 2019 and later. The prefix shows up when you open the file in an older Excel version.  But when you open the file in MS365 the _xlfn. prefix should not appear. If you are in MS365 and the prefix is visible anyway, it may have been typed into the formula. Just delete it, I would say.

Thanks, all sorted @Riny_van_Eekelen