Скачать или смотреть Microsoft Excel- 𝐒𝐔𝐁𝐓𝐎𝐓𝐀𝐋 𝐅𝐔𝐍𝐂𝐓𝐈𝐎𝐍 - 𝟑 𝐊𝐞𝐲 𝐓𝐈𝐏𝐒 !! 𝐓𝐢𝐩-𝟏𝟏 !! OFFICE 365 !! CONTINUOUS LEARNING

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.

𝑷𝒖𝒓𝒑𝒐𝒔𝒆 : Get a subtotal in a list or database

𝑹𝒆𝒕𝒖𝒓𝒏 𝒗𝒂𝒍𝒖𝒆: A number representing a specific kind of subtotal

𝐒𝐲𝐧𝐭𝐚𝐱 : =SUBTOTAL (function_num, ref1, [ref2], ...)

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬 : function_num - A number that specifies which function to use in calculating subtotals within a list. See table below for full list.
ref1 - A named range or reference to subtotal.
ref2 - [optional] A named range or reference to subtotal.

𝐎𝐭𝐡𝐞𝐫 𝐃𝐞𝐭𝐚𝐢𝐥𝐞𝐝 𝐄𝐱𝐜𝐞𝐥 𝐕𝐢𝐝𝐞𝐨𝐬:

• Vlookup in Excel-    • 𝑽𝑳𝑶𝑶𝑲𝑼𝑷 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 !! 𝑯𝑶𝑾 𝒕𝒐 𝒖𝒔𝒆 𝑽𝑳𝑶𝑶𝑲𝑼𝑷 𝒊𝒏 ...  
• Format Painter in Excel-    • How to Use 𝑭𝒐𝒓𝒎𝒂𝒕 𝑷𝒂𝒊𝒏𝒕𝒆𝒓 in Excel 2007/20...  

#msexcel #subtotalfunctioninexcel #continuouslearning