Forum Discussion
Solved
Excel formulas in Microsoft Teams
Hello Everyone, I have an excel document with a few basic formulas such as COUNTIFS. When I upload the form to Microsoft Teams, the COUNTIFS do not calculate. Is that a limitation in the excel fi...
I was able to figure it out. For some reason the default in Teams for "Calculation Options" under the "Formula" tab is set to manual. So it doesn't calculate the COUNTIFS. But once I changed it to "Automatic" it worked like indented.
Excel in Teams is actually Excel for web wrapped into Teams interface. COUNTIFS() definitely works in it.
In addition
Differences between using a workbook in the browser and in Excel (microsoft.com)
I was able to figure it out. For some reason the default in Teams for "Calculation Options" under the "Formula" tab is set to manual. So it doesn't calculate the COUNTIFS. But once I changed it to "Automatic" it worked like indented.