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:

Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.

Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.

Share your subscription.If you have a Microsoft 365 Family subscription, you can share your subscription and its benefits with up to 5 other people. Accounts you share with are not linked, and emails, OneDrive files & photos remain private (unless you share files or photos).

When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.

Windows 允许添加多个用户帐户以使用同一设备，使每个用户都有自己的设置、文档和应用程序。 例如，家长可以拥有自己的具有管理权限的帐户来管理设置和安装软件，而孩子可以拥有启用了家长控制的标准帐户来监视和限制其使用情况。

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

Learn more about updates for Windows 10 version 1903, including improvement and fixes, any known issues, and how to get the update.

You can easily insert a check mark (also known as a "tick mark") in Word, Outlook, Excel, or PowerPoint. These marks are static symbols. If you're looking for an interactive check box that you can click to check or uncheck, see: Add a check box or option button (Excel) or Make a checklist in Word. In your file, place the cursor where you want to insert the symbol.

Correct the #N/A errorin the VLOOKUP function. INDEX and MATCH offers more flexibility with matches. INDEX and MATCH can find an exact match, or a value that is greater or lesser than the lookup value.