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 t...
excel
office 365
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) ) )