Forum Discussion

drdoug1978's avatar
drdoug1978
Occasional Reader
Apr 01, 2026

Microsoft Excel Update Changed Formula

I've used Excel for the last 2-3 years to track changes in a sheet by month the data listed is added or changed.  The formula I've used worked fine until today, when I started receiving an _xlfn in the formula.  It now reads as follows:  

=IF(ISBLANK($A6),$A2,IF((_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0))>=$A$2,_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0),""))

 

My goal was to have Excel look if there were updated values in D6 and enter the most recent date associated with that value from A6 to A41.  Does Excel no longer support MAXIFS?

excel
office 365

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Apr 01, 2026

    I don't know why it is showing you that now.  My version still recognizes MAXIFS and excel is overly conservative about backwards compatibility (many outdated functions are still supported when possible).

    I would double check what version of excel you are running.  Although strange it might be you had a very old version installed and for some reason your shortcut is running that old version now or something? You can check under File->Account and then on the right side by 'About Excel'.  

    Also have you tried the online version?

    have you tried typing in a cell  =MAX   and see what functions show up in the tooltip popup and if MAXIFS is there?

    I am much more interested in figuring out why this is happening but here is an alternative approach I think would work and you might want to consider regardless:

    =IF(ISBLANK($A6),$A2,MAX($A2, A$7:A&41*(D$7:D$41>0) ) )