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
Boot Surface from a USB device - Microsoft Support
Note: If you don’t want to start your Surface from your USB drive, make sure the drive isn't inserted in the USB port on your Surface when you start it.
Start your PC in safe mode in Windows - Microsoft Support
Safe mode starts Windows in a basic state, using a limited set of files and drivers. If a problem doesn't happen in safe mode, this means that default settings and basic device drivers aren't causing the issue.
Get Windows updates as soon as they're available for your device
We're committed to delivering continuous innovation by releasing new features and enhancements into Windows 11 more frequently. Windows devices get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR). ...
Windows Startup Settings (including safe mode) - Microsoft Support
Safe mode starts Windows with a minimal set of drivers and services to help troubleshoot issues. If a problem doesn't reappear when you start your PC in safe mode, you can eliminate the default settings and basic device drivers and services as possible causes.
Windows で Bluetooth デバイスをペアリングする - Microsoft サポート
開始する前に、Windows 11 PC が Bluetooth をサポートしていることを確認します。 確認方法の詳細については、「Windows の Bluetooth の問題を解決する」を参照してください。 Bluetooth 機能を備えていないデバイスの追加についてのヘルプは、「Windows PC にデバイスを追加する」を参照してください。
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".
Getting started with Planner in Teams - Microsoft Support
Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft Teams for Education, Microsoft Teams personal, Microsoft Teams small business
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