Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
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
Combining Microsoft accounts - Microsoft Support
Share your subscription.If you have a Microsoft 365 Family subscription, you can share your subscription and its benefits with up to 5 other people. Accounts you share with are not linked, and emails, OneDrive files & photos remain private (unless you share files or photos).
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, Microsoft 365 for Mac, Microsoft 365 for Windows, Microsoft account dashboard, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
View sent email - Microsoft Support
After you send an email message, you might want to find that email and resend it or forward it to someone else. Outlook stores your messages in the Sent Items folder.If you don't see the Sent Items folder, you may need to change your Outlook settings.. You can find your Sent Items folder in your folder list.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
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
Encrypt messages by using S/MIME in Outlook on the web
A key icon in the message list or reading pane indicates an encrypted message.. If you normally use Conversation view, you'll have to open the message in a new window to read it. There will be a link on the message to make this easier.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Windows 10 update history - Microsoft Support
Learn more about updates for Windows 10 version 1903, including improvement and fixes, any known issues, and how to get the update.
How to log in to Microsoft Teams - Microsoft Support
Learn how to log in to Microsoft Teams with your Microsoft 365 account. This step-by-step guide from Microsoft Support walks you through the process of accessing Teams on desktop, web, and mobile devices.
Applies To: Microsoft Teams
KB4023057: Update Health Tools—Windows Update Service components
Important: If your device is out of support, it is no longer receiving security updates from Microsoft and may become more vulnerable to security risks and viruses.Therefore, we strongly recommend that you update to the latest version of Windows. Each version of Windows is supported for 18 months.
Get started with OneDrive (work or school) - Microsoft Support
Try it! OneDrive gives you one place to store, share, and sync your work or school files. As part of your organization's Microsoft 365 subscription, or SharePoint Server, you can save your files in OneDrive and then work with them from almost any device.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
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