{"id":385,"date":"2022-11-16T19:47:49","date_gmt":"2022-11-16T19:47:49","guid":{"rendered":"https:\/\/excelforgbs.com\/?p=385"},"modified":"2022-11-16T19:52:38","modified_gmt":"2022-11-16T19:52:38","slug":"sums-of-cells","status":"publish","type":"post","link":"https:\/\/excelforgbs.com\/?p=385","title":{"rendered":"Sums of cells"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">There is the simple summation function SUM().  Sums can also be done for only cells that meet conditions with SUMIF().  Two columns can be multiplied together with products for each row summed together using SUMPRODUCT().<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/excelforgbs.com\/video\/Functions\/Math\/Sum.mp4\"><\/video><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>There is the simple summation function SUM(). Sums can also be done for only cells that meet conditions with SUMIF(). Two columns can be multiplied together with products for each row summed together using SUMPRODUCT().<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_monsterinsights_skip_tracking":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-385","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=385"}],"version-history":[{"count":1,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions"}],"predecessor-version":[{"id":386,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions\/386"}],"wp:attachment":[{"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelforgbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}