Subtotal Formula of MS Excel

Subtotal Formula of Excel

The SUBTOTAL formula in Excel is used to perform various calculations (such as SUM, AVERAGE, COUNT, etc.) on a set of data within a list or table. The syntax for the SUBTOTAL formula is as follows:

scss
=SUBTOTAL(function_num, range)

             where:

• function_num is a number that corresponds to the type of calculation you want to perform (e.g., SUM = 9, AVERAGE = 1, COUNT = 2, etc.).
• range is the set of cells you want to perform the calculation on.

For example, to find the sum of the values in the range A1:A10, you would use the following formula:

scss
=SUBTOTAL(9, A1:A10)

Note that the SUBTOTAL formula can ignore values in the specified range that are in rows that are hidden by a filter, while a regular SUM formula will not. This makes the SUBTOTAL formula useful when you want to perform calculations on a subset of data that you have filtered in your worksheet.

[ध्यान दें कि SUBTOTAL सूत्र निर्दिष्ट श्रेणी में उन मानों को अनदेखा कर सकता है जो फ़िल्टर द्वारा छिपी हुई पंक्तियों में हैं, जबकि एक नियमित SUM सूत्र नहीं होगा। जब आप अपने वर्कशीट में फ़िल्टर किए गए डेटा के सबसेट पर गणना करना चाहते हैं तो यह सबटोटल फॉर्मूला उपयोगी बनाता है।]