SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Create a folder or subfolder in Outlook - Microsoft Support
To add a folder to the folder pane, do the following: In the left pane of Mail, Contacts, Tasks, or Calendar, right-click where you want to add the folder, and then click New Folder.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Block or unblock senders in Outlook - Microsoft Support
Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.
Applies To: New Outlook for Windows
Change your Microsoft account password - Microsoft Support
If you weren't able to change your password. If you couldn't change your password this way, see Reset your Microsoft account password. 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.
Applies To: Microsoft account dashboard
Upgrade to Windows 10 Pro - Microsoft Support
Windows 10 Pro offers more advanced security and business networking features, including: BitLocker Drive Encryption
Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To: Microsoft Teams
Troubleshoot Outlook email setup - Microsoft Support
If you try to add an IMAP account to Outlook, for example a Gmail account, Apple account, Yahoo account, or an account from your local ISP, and you're not prompted to enter your password, use the following steps to work around the problem.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Keyboard shortcuts in Windows - Microsoft Support
Do you want to learn how to navigate Windows using keyboard shortcuts? Whether you need to switch between apps, open the command prompt, or perform any other tasks, you can find a full list of keyboard shortcuts in Windows on this webpage. Discover how to save time and improve your productivity with these handy tips.
在 Windows 中查找 BitLocker 恢复密钥 - Microsoft 支持
个人设备的所有者或管理员激活了 BitLocker (在某些设备上也称为设备加密,) 通过“设置”应用或控制面板: 在这种情况下,激活 BitLocker 的用户选择了保存密钥的位置,或者在设备加密的情况下选择 (,) 自动将密钥保存到其 Microsoft 帐户。
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
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 for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile