Forum Discussion

drdoug1978's avatar
drdoug1978
Copper Contributor
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

3 Replies

  • djflobo's avatar
    djflobo
    Copper Contributor
    Apr 03, 2026

    I have a similar issue with an extensive file of mine - where most of the Formulas were corrupted - I suppose with a new Update from Excel debugger. Will post my problem as well - but good to know that others also experience problems!

  • m_tarler's avatar
    m_tarler
    Silver 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) ) )

     

    • drdoug1978's avatar
      drdoug1978
      Copper Contributor
      Apr 07, 2026

      M_Tarler, I tried your suggestion but it didn't work.  When I go to the Excel formula evaluator, it give me a NAME? error for MAXIF and MAXIFS functions.  I think this must have something to do with a Microsoft Update to Excel.  These sheets are only about 5 years old, so older version problems shouldn't affect them.  I figured out a workaround using an additional column to identify if the information was present in the cells I wanted to evaluate, then a MAX function to evaluate the data I pulled into that column.  Frustrating, though, that MAXIFS and MAXIF do not seem to be working.