The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:

Junk e-mail messages, also known as spam, can be a nuisance in your Inbox.The Junk E-mail Filter in Outlook identifies messages that are likely junk and moves them to the Junk E-mail folder. You can easily change the level of junk email protection or automatically delete junk email.

If you have followed the recommended steps at Connect Surface to a TV, monitor, or projector to connect your external display and are you're having trouble here are some things to try. Check for system updates. You can quickly check the health of your Surface drivers and firmware using the Surface app.

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.

Keep your favorites here or drag them to wherever you want. You can also create, delete, or rename your favorites folders. To arrange favorites alphabetically, press and hold (or right-click) any item in the list.

Are you looking for Contacts in the Mail app for Windows 10? The Mail app uses the People app for Windows 10 to store contact information. When you open a new message in Mail for Windows 10, start typing a contact's name or email address and Mail for Windows 10 will search the People app and display a list of suggestions for you to choose from.

Ensure these modes create an alert that is visible on your device. Make sure you have a device signal and Internet connection. Make sure your phone calls and text messages are getting through to your mobile device.

If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...

Add a caption to a picture or figure in a document. The Insert Caption feature in Word makes it easy to systematically add captions to pictures in a document.. In other Office apps, such as PowerPoint, you manually add a text box near the image and then group the text box and image.

Check the device. If the device doesn't appear to work at all (no lights appear on the device when it’s plugged in, or the cursor doesn't move or doesn't appear on the screen), connect the device to another PC and make sure the device works on that PC.