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
Change your Microsoft account password - Microsoft Support
If you weren't able to change your password. If you couldn't change your password this way, see Reset your Microsoft account password. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.
Applies To: Microsoft account dashboard
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To: Microsoft account dashboard
Troubleshoot problems updating Windows - Microsoft Support
Important: Before trying any of the solutions below, make sure you back up your personal files. You can back up your Windows PC, or insert a USB drive and use File Explorer to drag and copy important files to the USB drive.If you’re signing into Windows with a Microsoft account, your system settings will be automatically restored after updating, once you’re connected to the internet.
Ändern oder Zurücksetzen des Kennworts - Microsoft-Support
Wenn Sie das Kennwort ändern oder zurücksetzen möchten, das Sie für die Anmeldung bei Windows verwenden, haben Sie verschiedene Optionen. In diesem Artikel werden die verschiedenen Ansätze beschrieben, die Sie verfolgen können, unabhängig davon, ob Sie ein Microsoft-Konto oder ein lokales Konto verwenden, angemeldet sind oder auf dem Anmeldebildschirm angezeigt werden.
Troubleshooting verification code issues - Microsoft Support
That verification method isn’t working right now: Sometimes the block may be tied to the verification method you are using.Try using another verification method connected to your account. For example, if you are using SMS to verify yourself and are hitting a block, try using an alternate email that is connected to the account to receive your authorization code.
Applies To: Microsoft account dashboard
Check or change language settings - Microsoft Support
Microsoft's products and services work best if you use the same language and region across all your devices, and in all of your app and Store settings.
Applies To: Outlook.com, Microsoft Edge, OneDrive (home or personal)
Obtener la actualización más reciente de Windows
Los dispositivos Windows pueden obtener nuevas funciones en diferentes momentos, ya que Microsoft ofrece actualizaciones no relacionadas con la seguridad, correcciones, mejoras y mejoras a través de varias tecnologías de mantenimiento, incluida la implementación controlada de funciones (CFR). Windows te avisará si necesitas reiniciar el dispositivo para completar una actualización y ...
Erstellen eines Installationsmediums für Windows - Microsoft-Support
Erfahren Sie, wie Sie ein Installationsmedium für die Installation oder Neuinstallation von Windows 7, Windows 8.1 oder Windows 10 erstellen.
Check grammar, spelling, and more in Word - Microsoft Support
Word marks spelling, grammar, and stylistic issues with an underline. Control-click the word or phrase and choose one of the options. If Word incorrectly underlined a word as misspelled and you want to add that word to your dictionary so that Word will properly recognize it in the future, see Add or edit words in a spell check dictionary. If spelling or grammatical errors aren't underlined ...
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016