Nov 19 2021 02:13 PM
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
Nov 19 2021 02:31 PM
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)
Nov 19 2021 02:43 PM
Solution
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.
Nov 19 2021 02:43 PM
Solution
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.