Скачать или смотреть How to use the Excel SUBTOTAL function│HINDI│Why you should use?

This Video 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.
The Excel SUBTOTAL function returns an aggregate result for supplied values. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others (see table below), and SUBTOTAL function can either include or exclude values in hidden rows.

Syntax
SUBTOTAL(function_num,ref1,[ref2],...)

The SUBTOTAL function syntax has the following arguments:

Function_num Required. The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.

Ref1 Required. The first named range or reference for which you want the subtotal.

Ref2,... Optional. Named ranges or references 2 to 254 for which you want the subtotal.

Remarks
If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting.

For the function_num constants from 1 to 11, the SUBTOTAL function includes the values of rows hidden by the Hide Rows command under the Hide & Unhide submenu of the Format command in the Cells group on the Home tab in the Excel desktop application. Use these constants when you want to subtotal hidden and nonhidden numbers in a list. For the function_Num constants from 101 to 111, the SUBTOTAL function ignores values of rows hidden by the Hide Rows command. Use these constants when you want to subtotal only nonhidden numbers in a list.

The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use.

The SUBTOTAL function is designed for columns of data or vertical ranges. It is not designed for rows of data or horizontal ranges. For example, when you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL(109,B2:G2), hiding a column does not affect the subtotal. But, hiding a row in a subtotal of a vertical range does affect the subtotal.

If any of the references are 3-D references, SUBTOTAL returns the #VALUE! error value.

Notes

The SUBTOTAL function always requires a numeric argument (1 through 11, 101 through 111) as its first argument. This numeric argument is applied to the subtotal of the values (cell ranges, named ranges) that are specified as the arguments that follow.

Please Watch below Excel Videos too:

1. Basic MS-Excel Tutorial for Beginners- !! Hindi PART 1 !! A Comprehensive Guide for Everyone
   • What is MS-Excel? Full Tutorial for Beginn...  

2. Formatting in MS-Excel For Beginners- !! Hindi PART 2 !! A Comprehensive Guide for Everyone
   • Formatting in MS-Excel For Beginners- !! H...  

3. Excel SHORTCUTS Tutorial for Beginners in HINDI !! PART 3 !! Keyboard Tricks And Uses
   • Excel SHORTCUTS Tutorial for Beginners in ...  

4. How to Use Sum Function in EXCEL (4 Easy Methods) !! PART 4 !! in Hindi
   • Sum Function in EXCEL with 4 Easy Methods ...  

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
   / @comtutor  
फेसबुक पर पसंद करने के लिए क्लिक करें
  / comtutor4u  
ट्विटर पर फॉलो करने के लिए क्लिक करे
  / comtutor4u