You May Also Like

تمتلئ أجهزة ماك بأدوات لقطة شاشة قوية. يمكنك التقاط لقطة شاشة باستخدام اختصار لوحة المفاتيح ، وسحب أداة رسومية مناسبة ...
Read More
كيفية عمل لقطة للشاشة على جهاز ماك
ما هو منفذ K Lock في الحاسوب المحمول؟ إذا كنت تمتلك حاسباً محمولاً فالطبع ترغب في الإستفادة بجميع المميزات المتاحة ...
Read More
K Lock ما هو و كيف أستخدمه
تعد خوارزميات التشفير أحد مكونات أمن نقل البيانات الإلكترونية. يتم اتخاذ الخطوات الرياضية الفعلية وتسجيلها عند تطوير الخوارزميات لأغراض التشفير ...
Read More
ما هي خوارزميات التشفير وما هو أشهرها

how to create a subtotal in Excel?

The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data. For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order.

The Subtotal command will create a hierarchy of groups, known as an outline, to help organize your worksheet.

Important: Your data must be correctly sorted before using the Subtotal command

To create a subtotal in Excel:

In our example, we will use the Subtotal command with a T-shirt order form to determine how many T-shirts were ordered in each size (Small, Medium, Large, and X-Large).

This will create an outline for our worksheet with a group for each T-shirt size and then count the total number of shirts in each group.

  1. First, sortyour worksheet by the data you wish to subtotal. In this example, we will create a subtotal for each T-shirt size, so our worksheet has been sorted by T-shirt size from smallest to largest.

  2.       Select the Data tab, then click the Subtotal command.

  1. The Subtotal dialog box will appear. Click the drop-down arrow for the At each change in: field to select the column you wish to subtotal , In our example, we’ll select T-Shirt Size.

  2. Click the drop-down arrow for the Use function: field to select the function you wish to use In our example, we’ll select COUNT to count the number of shirts ordered in each size.

  3. In the Add subtotal to: field, select the column where you want the calculated subtotal to appear In our example, we’ll select T-Shirt Size.

  4. When you’re satisfied with your selections then click OK.

  5.    The worksheet will be outlined into groups, and the subtotal will be listed below each group  In our example, the data is now grouped by T-shirt size, and the number of shirts ordered in that size appears below each group.

To remove subtotals in Excel:

Sometimes you may not want to keep subtotals in your worksheet, especially if you want to reorganize data in different ways. If you no longer wish to use subtotaling, you’ll need remove it from your worksheet.

  1. Select the Data tab, then click the Subtotal command.

  2. The Subtotal dialog box will appear. Click Remove All.

  3. All worksheet data will be ungrouped  and the subtotals will be removed.

Last Article