Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Mar 23, 2025

Filter Function

Morning

I am using Microsoft Office 365, suddenly the Function "Filter" is Excel is not working. There is an expression (_xlfn._xlws) appeared in front of a formula. I searching on this expression and appeared that the function is not supported.  What is the alternative?

I have this formula in my excel file currently:

=IFERROR(SUM(_xlfn._xlws.FILTER('BB'!C12:C104,'BB'!E12:E104='CC'!B4)),"")

 

Thanks

 

 

office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Mar 23, 2025

    Please indicate on which channel/build of Microsoft 365 you are. That's in File->Account and looks like

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 23, 2025

    The _xlfn._xlws prefix in your formula means that your version of Excel does not support the FILTER function. This can be happens if:

    You opened the file in an older version of Excel (Excel 2019, 2016, or earlier), which does not support FILTER. If using older Excel, replace FILTER with SUMIFS or SUMPRODUCT.

    or…

    Your Office 365 installation is outdated and needs an update to restore FILTER. .

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

Resources