{"id":1186,"date":"2018-02-16T22:27:49","date_gmt":"2018-02-16T16:27:49","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1186"},"modified":"2018-02-16T22:27:49","modified_gmt":"2018-02-16T16:27:49","slug":"conditional-count-multiple-conditions","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1186","title":{"rendered":"Count cells with condition &#8211; multiple conditions"},"content":{"rendered":"<p>We did see who we can get total of a column for a certain month in certain year using SUMIFS.<\/p>\n<p>SUMIFS got a sister function, COUNTIFS<\/p>\n<p>Which will count how many times cells found with more than 1 condition<\/p>\n<p>So, when you have a table like this&#8230;<\/p>\n<p><!--more--><\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/02\/Screenshot_1-e1518798122805.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1187\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/02\/Screenshot_1-300x239.jpg\" alt=\"\" width=\"648\" height=\"516\"><\/a><\/p>\n<p>All you need to do is to get how many times a certain month found, is to use this formula&#8230;<\/p>\n<p><code>=COUNTIFS(B:B,\"&gt;=\"&amp;DATE(F6,G6,1),B:B,\"&lt;\"&amp;DATE(F6,G6+1,1))<\/code><\/p>\n<p>&nbsp;<\/p>\n<p>As you can see in cell H6<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function, COUNTIFS Which will count how many times cells found with more than 1 condition So, when you have a table like this&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1187,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,3,38,7,58],"tags":[119,192],"class_list":["post-1186","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-countifs","category-formulas","category-math-and-trig","category-statistical","category-sumifs","tag-countifs","tag-sumifs"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1186"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1186\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1187"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}