Forum Discussion
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 file within Teams?
Is there a list of formulas that DO work in Teams?
Thanks in Advance
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.
2 Replies
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.
