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
End of support for Cortana - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
View previous versions of Office files - Microsoft Support
Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Excel 2021, Word 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016
Create a system repair disc - Microsoft Support
In the left pane, click Create a system repair disc, and then follow the steps. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Create and use modern pages on a SharePoint site
Learn how to add a page to a SharePoint Online site. Add web parts. Web parts are the building blocks of your page. For more information on the different types of web parts and how to use them, check out Using web parts on pages.. If you have the content pane enabled:
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint operated by 21Vianet
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
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 Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Einlösen eines Geschenkgutscheins oder Codes für Ihr Microsoft-Konto
So lösen Sie ein Geschenk Karte, Xbox-Downloadcode oder Token ein. Sowohl Microsoft- als auch Xbox-Geschenkkarten und Downloadcodes und Token funktionieren auf die gleiche Weise: Nach der Einlösung in Ihr Microsoft-Konto können Sie Ihr Guthaben bei Microsoft Store-Website, auf Windows oder Xbox ausgeben, und Sie können Downloads für die neuesten Apps, Spiele, Filme, TV-Sendungen sowie ...
Applies To:
Microsoft account dashboard
Get started with Microsoft Teams - Microsoft Support
Training: Microsoft Teams is a collaboration app built for hybrid work to help you and your team stay informed, organized, and connected. Learn how in this video.
Applies To:
Microsoft Teams
Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Microsoft 365 for business If your business subscription plan includes the desktop version of the Microsoft 365 apps you won't see an option to install it unless someone in your organization assigned a license to you.. Learn how to check this in What Microsoft 365 business product or license do I have? or if you're a Microsoft 365 admin responsible for assigning licenses to people in your ...
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
How to add an email address or phone number to your Microsoft account
Tip: Creating an Outlook.com email address gives you a brand-new email address that is attached to your existing Microsoft account.This makes several benefits and features available to you within the Microsoft suite of products, particularly within Outlook. You might want to do this if your Microsoft account is not currently tied to an Outlook.com email address.