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

Copy images and text from one PC to another with a cloud-based clipboard. Not only can you can paste from your clipboard history, but you can also pin the items you find yourself using all the time.

If you have problems activating online or don't have an internet connection, you can activate by phone. Follow the “Activate using an Internet Connection” method below to attempt via the internet. Automated System & Live Support Advocate: To get the telephone number for activation support, follow the “Activate by Phone” method below ...

Note that you won't see repair, change, or modify options for all apps and programs. Repair options from the Settings page. Select Start > Settings > Apps > Apps & features. Apps & features in Settings.

This means your files won’t be downloaded again if they haven’t changed. If you had chosen to sync only some folders before the reset, you will need to do that again once sync has completed. Read Choose which OneDrive folders to sync to your computer for more information.

Note: If the steps under this New Outlook tab don't work, you may not be using new Outlook for Windows yet. Select the Classic Outlook tab and follow those steps instead. Change the font size in your new Outlook message list. From the menu, select View > View settings.

Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.

Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings.In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings

With Word for the web running in your web browser, you can: Create documents to add and format text, images, and page layouts.

If you want multiple copies of a printout, change the number of copies in the Print page: On Windows 7 or earlier, at the top of the Print page is a box labeled Copies with up and down arrows for you to choose how many copies of the document you want. Make your choice (either by entering a number or using the arrows), and then click Print.