Fungsi Subtotal Excel

Rumus ini akan menghasilkan subtotal dari sebuah daftar data/list atau database. Biasanya kita menggunakan Perintah Subtotal
dalam Outline group yang ada di Menu Data. Setelah daftar subtotal list dibuat, maka anda dapat memodifikasi fungsi SUBTOTAL nya

Rumus:

SUBTOTAL(function_num, ref1, ref2, …)

Function_num adalah angka 1 s/d 11 (kalau menjumlahkan termasuk nilai yang tersembunyi) atau 101 s/d 111 (tidak termasuk nilai yang tersembunyi) yang menyatakan fungsi yang mana yang digunakan untuk menghitung subtotals dalam sebuah table data.

Function_num
(includes hidden values)

Function_num
(ignores hidden values)

Function

1

101

AVERAGE

2

102

COUNT

3

103

COUNTA

4

104

MAX

5

105

MIN

6

106

PRODUCT

7

107

STDEV

8

108

rolex replica watches  |
omega replica watches  |
longines replica watches  |
rolex replica watches  |
breitling replica watches  |
rolex replica wathces  |
omega replica watches  |
Windows 7 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Windows 7 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Windows 7 ultimate key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Office 2013 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Office 2016 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
windows 7 Activation Key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
windows 7 Activation Key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
windows 7 home premium key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Office 2016 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |
Windows 7 key  |
Windows 7 key  |
windows 7 professional key  |
windows 7 ultimate key  |
windows 7 home premium key  |
windows 7 Activation Key  |
windows 8 key  |
Windows 8 Enterprise key  |
Windows 8 Professional key  |
windows 8.1 professional key  |
Windows 10 key  |
windows 10 product key  |
Windows 10 serial key  |
windows 10 pro key  |
windows 10 home key  |
Office 2010 key  |
Office Professional Plus 2010 key  |
Office 2013 key  |
office professional plus 2013 key  |
Office 2016 key  |
Office Professional 2016 key  |
office professional plus 2016 key  |
Office 2016 for Mac Key  |

STDEVP

9

109

SUM

10

110

VAR

11

111

VARP

Ref1, ref2 adalah angka Range atau Referensi 1 s/d 254 yang akan disubtotalkan.

Contoh:

Data:

Perhatikan data 14 s.d 16 disembunyikan

Dengan menggunakan fungsi subtotal maka hasilnya adalah sebagai berikut:

Leave a Reply

Your email address will not be published. Required fields are marked *