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
Surface power supplies and charging requirements
For info on how to properly care for the power cord and power supply, see Clean and care for your Surface.. Safety and regulatory information. To view the safety and regulatory information for Surface and Surface power supplies, including shipping information and AC power cord safety, see Product safety warnings and instructions.. Where to find a power supply
Switch from working offline to online - Microsoft Support
In Outlook, you have the flexibility to make Outlook work online or offline with your mail server. Select a tab option below for the version of Outlook you're using.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Add an email account to Outlook for Windows - Microsoft Support
Outlook won't accept my password. If you've forgotten the password for a Microsoft account, user our sign-in helper to get back into your account.. If you know you’re using the correct password for your email account but Outlook won’t accept it, you might have an email account that requires additional security.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, New Outlook for Windows
What to try if your Surface touchscreen doesn't work
Solution 4: Reset Surface. If you’re still having a problem with your touchscreen, try resetting your Surface. To learn how, see Restore or reset Surface for Windows and follow the recommended steps for "Reset this PC.". After the reset and device setup, use touch to open an application like Microsoft Edge or another web browser, and try to scroll pinch to zoom, swipe in from the right, and ...
Change your status in Microsoft Teams - Microsoft Support
Set a duration for your status. When you want to change your status for a specific period of time—for example, to set Do not disturb for an hour of concentrated work—you can set a duration so that Teams will automatically reset your status at the end of the allotted time.. You can set durations for any status except Available.. Select your profile picture > current status > Duration.
Applies To: Microsoft Teams
Use inbox rules in Outlook - Microsoft Support
Use rules to automatically perform specific actions on email that arrives in your inbox. For example, you can create rules that will change the importance level of messages as they come in, automatically move them to other folders, or delete them based on certain criteria.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows
Use the Tasks app in Teams - Microsoft Support
List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft To Do
Sign in and create multiple profiles in Microsoft Edge
With Edge Chromium, you can add multiple profiles. Profiles allow multiple users to operate in a shared environment while maintaining access to their personalized browser settings, bookmarks, and extensions.
Excel functions (by category) - Microsoft Support
Function. Description. CUBEKPIMEMBER function. Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance.
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