SOLVED

Excel formulas in Microsoft Teams

Copper Contributor

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 

2 Replies

@bradshimkus 

Excel in Teams is actually Excel for web wrapped into Teams interface. COUNTIFS() definitely works in it.

image.png

In addition

Differences between using a workbook in the browser and in Excel (microsoft.com)

Excel functions (alphabetical) (microsoft.com)

best response confirmed by bradshimkus (Copper Contributor)
Solution

@Sergei Baklan 

 

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.

bradshimkus_0-1637361787131.png

 

1 best response

Accepted Solutions
best response confirmed by bradshimkus (Copper Contributor)
Solution

@Sergei Baklan 

 

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.

bradshimkus_0-1637361787131.png

 

View solution in original post