This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

Establishing internet boundaries is an important way to protect yourself and your family from inappropriate web content. Microsoft Family Safety web and search filters work across any Windows, Xbox and mobile device that has the Microsoft Edge browser and Family Safety apps installed.

Look in the Surface app. The easiest way to find which Surface model you have is to use the Surface app. It shows the model name of your Surface device and each Surface accessory.

With a Microsoft or Xbox gift card, you let the lucky recipient choose the gift they want.There are no fees or expiration dates, and either card can be used to buy: Popular games, apps, and add-ons for Windows and Xbox.

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:

Note: For more info about the minimum system requirements for Windows 11, see Windows 11 specs, features, and computer requirements.

Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.

If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history.On the Order history page, find your order and then look under Status.. Open Rewards dashboard

注意: 如果数据位于 Excel 表中，则“转置”功能不可用。您可以 将 表格 转换为区域 中首先，或可以使用 TRANSPOSE 函数 旋转的行和列。

Right click or long press on Command Prompt and select Run as administrator.