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

Sign in to www.office.com from a web browser and start using the apps on the web or access other web services associated with your account such as OneDrive.. How you sign in to an installed Office app depends on your device.

Start page numbering on Page 3 - double-sided printing. If the first page of your document is a cover page, the second page is a table of contents, and you want the third page to show “Page 1”, see Start page numbering on Page 3 - double-sided printing.

Problem. Description. Quotation marks appear in result string. Use commas to separate adjoining text items. For example: Excel will display =CONCATENATE("Hello ""World") as Hello"World with an extra quote mark because a comma between the text arguments was omitted.

Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.

Note: If you have a message open in its own window instead of the Reading pane, the Backspace key will not archive the message. You have to close the message and view it in the Reading pane for the Backspace keyto archive the message. When the message is open in a new window, the only way to archive the message is by using the Archive button on the ribbon.

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.

Access, download, or run the Surface app and the Surface Diagnostic Toolkit to help find and solve Surface problems.

To upgrade to Windows 11, you need enough space on your hard drive for the installation to take place. To view how much hard drive space is available on your computer, select File Explorer on the taskbar (known as Windows Explorer in Windows 7) or press Windows logo key + E. Then select Computer or This PC and look under Hard Disk Drives or under Devices and drives.