SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App
Filter junk email and spam in Outlook - Microsoft Support
When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports
Applies To: Office for business, Office 365 Small Business, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Send large files with Outlook - Microsoft Support
Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Check or change language settings - Microsoft Support
Microsoft's products and services work best if you use the same language and region across all your devices, and in all of your app and Store settings.
Applies To: Outlook.com, Microsoft Edge, OneDrive (home or personal)
First things to know about teams in Microsoft Teams
A team is a group of people gathered to get something big done in your organization. Sometimes it’s your whole organization.. Teams are made up of channels, which are the conversations you have with your teammates.Each channel is dedicated to a specific topic, department, or project. For example, the Mark 8 Project team has General, Design, Digital Assets Web, Go to Market Plan, and Research ...
Applies To: Microsoft Teams
Word for Windows training - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Office for business
Troubleshooting verification code issues - Microsoft Support
That verification method isn’t working right now: Sometimes the block may be tied to the verification method you are using.Try using another verification method connected to your account. For example, if you are using SMS to verify yourself and are hitting a block, try using an alternate email that is connected to the account to receive your authorization code.
Applies To: Microsoft account dashboard
Multiply and divide numbers in Excel - Microsoft Support
Multiply numbers in different cells by using a formula. You can use the PRODUCT function to multiply numbers, cells, and ranges.. You can use any combination of up to 255 numbers or cell references in the PRODUCT function. For example, the formula =PRODUCT(A2,A4:A15,12,E3:E5,150,G4,H4:J6) multiplies two single cells (A2 and G4), two numbers (12 and 150), and three ranges (A4:A15, E3:E5, and H4 ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Using the new Bing on the Windows taskbar - Microsoft Support
Open directly from the Search bar. If the Bing Chat icon is displaying in your Search bar on the taskbar, simply select it and Bing Chat will open in Microsoft Edge.. Open in Search Home. Here's how: Select the Search icon or the Search bar on your taskbar.