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
Choose between the 64-bit or 32-bit version of Office
I know which version I want. How do I install it? The 64-bit version of Microsoft 365 is automatically installed unless you explicitly select the 32-bit version before beginning the installation process.. To install either the 32 or 64-bit version of Microsoft 365, Office 2021, or Office 2019, follow the steps in Install Office on a PC.
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Pin apps and folders to the desktop or taskbar - Microsoft Support
To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar.
Fix Wi-Fi connection issues in Windows - Microsoft Support
Things to try first. Try these things first to help you fix or narrow down the connection problem. Run Get Help to troubleshoot and fix common connection problems. Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet
Protect yourself from tech support scams - Microsoft Support
The classic cold-call scam. The scammers call you and claim to be from the tech support team of Microsoft or another company. They offer to help solve your computer "problems".
Windows 11 and Secure Boot - Microsoft Support
Learn how to change settings to enable Secure Boot if you are not able to upgrade to Windows 11 because your PC is not currently Secure Boot capable.
Change macro security settings in Excel - Microsoft Support
Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Import Gmail to Outlook - Microsoft Support
Step 1: Prepare Gmail for connecting to Outlook. Before you connect your Gmail account and Outlook, you need to prepare your Gmail account: turn on 2-step verification for Gmail and then create an app password that Outlook/Microsoft 365 will use with your Gmail address to make the connection.. Step 2: Add your Gmail account to Outlook
Applies To: Outlook 2016, Outlook 2013, Outlook Web App for Office 365, Outlook on the web, Outlook on the web for Exchange Server 2016, Outlook Web App
Créer un support d’installation pour Windows - Support Microsoft
Pour créer le support d’installation, voici ce dont vous avez besoin : Un PC disposant d’une connexion Internet fiable. La durée du téléchargement variera en fonction de votre connexion internet.