Forum Discussion
Microsoft Excel Update Changed Formula
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) ) )
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.