Menghitung dan Fungsi Sum di Excel

Fathoni

30 Jan, 2015

Fungsi yang paling umum digunakan di Excel adalah fungsi menghitung dan jumlah. Anda dapat menghitung dan jumlah berdasarkan satu kriteria atau beberapa kriteria.

Menghitung
Untuk menghitung jumlah sel yang berisi angka, menggunakan fungsi COUNT.

Countif
Untuk menghitung sel berdasarkan satu kriteria (misalnya, lebih tinggi dari 9), menggunakan fungsi COUNTIF berikut.

COUNTIFS
Untuk menghitung sel berdasarkan beberapa kriteria (misalnya, hijau dan lebih tinggi dari 9), gunakan COUNTIFS fungsi berikut.

Jumlah
Untuk jumlah kisaran sel, menggunakan fungsi SUM.

Sumif
Untuk jumlah sel berdasarkan satu kriteria (misalnya, lebih tinggi dari 9), gunakan fungsi SUMIF berikut (dua argumen).

Untuk jumlah sel berdasarkan satu kriteria (misalnya, hijau), menggunakan fungsi SUMIF berikut (tiga argumen, argumen terakhir adalah rentang untuk jumlah).

SUMIFS
Untuk jumlah sel berdasarkan beberapa kriteria (misalnya, biru dan hijau), gunakan fungsi SUMIFS berikut (argumen pertama adalah rentang untuk jumlah).

Catatan umum: dengan cara yang sama, Anda dapat menggunakan AVERAGEIF dan AVERAGEIFS fungsi sel-rata berdasarkan satu atau beberapa kriteria.

<!--

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY6Jra8eWVz--xnxEv_hsKMlpVLZOw:1732404238676';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3976261034658282476','//icollecta.blogspot.com/2015/01/menghitung-dan-fungsi-sum-di-excel.html','3976261034658282476');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3976261034658282476', 'title': 'All for You', 'url': 'https://icollecta.blogspot.com/2015/01/menghitung-dan-fungsi-sum-di-excel.html', 'canonicalUrl': 'https://icollecta.blogspot.com/2015/01/menghitung-dan-fungsi-sum-di-excel.html', 'homepageUrl': 'https://icollecta.blogspot.com/', 'searchUrl': 'https://icollecta.blogspot.com/search', 'canonicalHomepageUrl': 'https://icollecta.blogspot.com/', 'blogspotFaviconUrl': 'https://icollecta.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-38705278-1', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22All for You - RSS\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3976261034658282476/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/798212639698269959/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-1560747079619197', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d78375fb222d99b3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '798212639698269959', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVUnEjxmVijExLO7prC-Bf9BhA1tmgpp2mIt-_OCjq3g9o0eITQY73Lq_B2qwaV8mPcjXOxTCJ5mAkBdX-zxQ1odGFTgYCTW2Hj93oh5INmuLLEE1TMv-juXunaBq9Keccbas4V_6PxMe5/s72-c/count-function.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVUnEjxmVijExLO7prC-Bf9BhA1tmgpp2mIt-_OCjq3g9o0eITQY73Lq_B2qwaV8mPcjXOxTCJ5mAkBdX-zxQ1odGFTgYCTW2Hj93oh5INmuLLEE1TMv-juXunaBq9Keccbas4V_6PxMe5/s1600/count-function.png', 'pageName': 'Menghitung dan Fungsi Sum di Excel', 'pageTitle': 'All for You: Menghitung dan Fungsi Sum di Excel'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Menghitung dan Fungsi Sum di Excel', 'description': 'Fungsi yang paling umum digunakan di Excel adalah fungsi menghitung dan jumlah. Anda dapat menghitung dan jumlah berdasarkan satu kriteria a...', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVUnEjxmVijExLO7prC-Bf9BhA1tmgpp2mIt-_OCjq3g9o0eITQY73Lq_B2qwaV8mPcjXOxTCJ5mAkBdX-zxQ1odGFTgYCTW2Hj93oh5INmuLLEE1TMv-juXunaBq9Keccbas4V_6PxMe5/s1600/count-function.png', 'url': 'https://icollecta.blogspot.com/2015/01/menghitung-dan-fungsi-sum-di-excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 798212639698269959}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': '#Search and Icons', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'PageList', 'sectionId': 'header-main', 'id': 'PageList50'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost50', 'postId': '7436093338637726709'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '798212639698269959', 'title': 'Menghitung dan Fungsi Sum di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVUnEjxmVijExLO7prC-Bf9BhA1tmgpp2mIt-_OCjq3g9o0eITQY73Lq_B2qwaV8mPcjXOxTCJ5mAkBdX-zxQ1odGFTgYCTW2Hj93oh5INmuLLEE1TMv-juXunaBq9Keccbas4V_6PxMe5/s1600/count-function.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML1'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': [{'title': 'Connectify Hotspot Pro \x26amp; Dispatch Pro 8.0.0.30686', 'id': 2655570637012845177}, {'title': 'Beungong Meulu dan Beungong Peukeun', 'id': 3504814329225322177}, {'title': 'Soekarno: Proklamator dan Presiden Pertama Indonesia', 'id': 8308504018676453940}, {'title': 'Ice Age 4 Continental Drift (2012) DVDRip', 'id': 1898697824908181274}, {'title': 'Pertolongan Pertama Balita Mengalami Demam Tinggi', 'id': 2682847614426360496}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}, {'title': 'JetScript Options', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML59'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList50', 'header-main', document.getElementById('PageList50'), {'title': 'Menu', 'links': [{'isCurrentPage': false, 'href': '/p/about.html', 'title': 'About'}, {'isCurrentPage': false, 'href': '/search/label/Teknologi?max-results\x3d10', 'title': 'Tech'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Windows?max-results\x3d10', 'title': 'Windows'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Software?max-results\x3d10', 'title': 'Windows Software'}, {'isCurrentPage': false, 'href': '/search/label/Windows%20OS?max-results\x3d10', 'title': 'Windows OS'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Dropdown-#2'}, {'isCurrentPage': false, 'href': '#', 'title': 'Android'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Sub Menu #1'}, {'isCurrentPage': false, 'href': '/p/contact.html', 'title': 'Contact'}, {'isCurrentPage': false, 'href': '/p/sitemap.html', 'title': 'Sitemap'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost50', 'before-blog', document.getElementById('FeaturedPost50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'ads-post', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML59', 'jet-options', document.getElementById('HTML59'), {}, 'displayModeFull'));
</script>
</body>

-->