Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

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:

After you export your contacts, use Excel to open the CSV file and check that there's data. When you close the file, Excel will prompt you a few times with "are you sure you want to save it in CSV format?"

Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.

Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...

When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.

Troubleshooting: I don't see Automatic Replies. If you don't see Automatic Replies after selecting File, you're probably using a Gmail, Yahoo, or other POP or IMAP account that doesn't support the Outlook Automatic Replies feature.You can set up a rule that will reply to incoming messages—if you leave Outlook running while you're away.

If your account has been hacked, use our sign-in helper tool below to help guide you to the right solutions. The tool will ask for your email address or phone number, and either show appropriate self-help, or offer the chance to talk to an agent.

If prompted, enter your password. However, if you have two-factor authentication set up, you might see a window asking you to Create an app-specific password.To obtain an app-password, do the following:

For information about Windows update terminology, see the article about the types of Windows updates and the monthly quality update types. Note Follow @WindowsUpdate to find out when new content is published to the Windows release health dashboard.