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
Enable or disable ActiveX settings in Office files
Learn how to enable or disable ActiveX settings for Office files to improve security and functionality. Follow the steps for different Office versions.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Insert or delete rows and columns - Microsoft Support
Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
How to redeem Microsoft Rewards points - Microsoft Support
Note: Offers vary by country.Be sure to redeem your rewards points in the same region you signed up in. Do not use a VPN while trying to redeem points. When redeeming points, use a mobile or landline phone number for authentication and not a VoIP phone number.
Applies To: Microsoft account dashboard
Microsoft Support
Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.
Get updates for apps and games in Microsoft Store
Learn more. Fix problems with apps from Microsoft Store. Manage your purchases from the Microsoft Store. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.
Change or reset Internet Explorer settings - Microsoft Support
Change Internet Explorer settings. There are many changes you can make to customize your browsing experience in Internet Explorer. To view all settings and options, open Internet Explorer on the desktop, select Tools > Internet options.. Reset Internet Explorer settings
How to add an account in OneDrive - Microsoft Support
To add another account to OneDrive on your computer. If you already have a personal OneDrive account set up, you can only add work or school accounts.
Applies To: OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Meet Windows 11 - Microsoft Support
Make the everyday easier with Windows 11. When there's a lot to do, Windows 11 helps you get it done. With intuitive navigation and new multitasking tools, it brings you the performance you want and the security you need.
Create, change, or customize a view - Microsoft Support
For more details about dark mode, see Dark Mode in Outlook.. Types of views. There are several different types of views you can choose when creating new view. Table A table view shows your information in rows and columns.This is one of the most effective views for email messages.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016