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:

A message that is encrypted by Microsoft 365 Message Encryption is delivered to a recipient’s inbox just like any other email message. If the recipient has Outlook 2016 and a Microsoft 365 email account, they'll see an alert about the item's restricted permissions in the Reading pane.

This video is part of a training course called Advanced IF functions.. Syntax. COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments:

On the Home tab, select the ellipsis (…) next to the list buttons (as illustrated below), and then select Increase List Level.. Keyboard shortcut for Increase List Level: Tab.. Keyboard shortcut for Decrease List Level: Shift+Tab.. The cursor must be at the beginning of the paragraph for the keyboard shortcut to take effect.

Training: Watch this video to learn how to switch your Outlook calendar view between day, week, or month views, change the week displayed, and see different shared calendars.

When you type in an email address, for example cheryl.parsons64@yahoo.com, Outlook returns all email messages that contain that email address anywhere in the subject, message body, or many types of attachments as well as messages from that email address.To limit your search results to emails from an email address, type from:cheryl.parsons64@yahoo.com in the search box.

Screen time reporting shows daily and weekly details about when and for how long your family member used their devices. Gain insight into the amount of time your family member spends on a particular social media app, game or web browser and decide whether you would like to enable screen time limits for any connected devices. To view screen time for a family member, tap Today, then Screen time ...

When trying to install updates from Windows Update you might receive "Updates Failed. There were problems installing some updates, but we'll try again later" with Errors: 0x80073701, 0x800f0988

Training: Keep your Microsoft 365 for business profile up to date so your teammates can get to know you and your skills.

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.