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. ...

Published August 2021. This article is intended for users who are not able to upgrade to Windows 11 because their PC is not currently Secure Boot capable.

On the Outlook status bar, if you see Disconnected, Working Offline, or Trying to connect…, then Outlook can't reach the email server to send your mail.. To fix this problem, on the ribbon, select the Send/Receive tab, then, in the Preferences group, select Work Offline to toggle between offline mode and online mode.You may need to open the message and send it again or choose Send/Receive.

In Outlook, the black color theme includes dark mode, which provides a black background (instead of white) for the message window. You can switch to a white background for the message window if you prefer.

Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)

Use the People page to create, view, and edit contacts, contact lists, and groups. Create new contacts from scratch, or add someone as a contact from their profile card.

A guide to help you identify and access your Microsoft account. How to check if your email is a Microsoft account? Go to the Microsoft account sign-in page at https://account.microsoft.com and enter your email address.

Note: If you are in tablet mode, desktop icons are not displayed.To see your desktop icons in tablet mode, go to Start > Settings > System > Tablet, then select Change additional tablet settings.Under When I'm using tablet mode, make sure that Hide app icons on the taskbar and Automatically hide the taskbar are both set to Off.

If you get an email about unusual activity on your Microsoft account, or if you’re worried that someone else might have used your account, go to the Recent activity page.You’ll see when your Microsoft account was signed in during the last 30 days, along with any device or app-specific info.

Tip: If you're already in Word for the web, get to the letter templates by going to File > New, and then below the template images click More on Office.com. You'll be on the Templates for Word page. In the list of categories, click Letters.