=SUM(COUNTIF(M1:M12,{“A”,”B”,”C”}))
\n=SUM(COUNTIFS(M1:M12,{“A”,”B”,”C”},B1:B12,{“D”,”E”,”F”))<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
1. Countifs with multiple criteria in single criteria range =SUM(COUNTIF(M1:M12,{“A”,”B”,”C”})) =SUM(COUNTIFS(M1:M12,{“A”,”B”,”C”},B1:B12,{“D”,”E”,”F”)) <\/p>\n","protected":false},"author":3,"featured_media":0,"parent":103,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-105","page","type-page","status-publish","hentry"],"jetpack-related-posts":[{"id":644,"url":"https:\/\/potterdreams.com\/clay\/interest\/quotes\/the-universal-golden-rule\/","url_meta":{"origin":105,"position":0},"title":"\u201cTHE UNIVERSAL GOLDEN RULE\u201d","author":"clay","date":"September 26, 2013","format":false,"excerpt":"Came across this, and thought it's good to post it here as a reference :) Treat other people with decency because you believe that they deserve that - regardless of what any gods might think on the matter-ATHEISM Choose thou for thyself that which thou choosest for thyself-BAHA'I FAITH Make\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1135,"url":"https:\/\/potterdreams.com\/clay\/special-stuff\/afterthought-reactions\/on-teaching-children\/","url_meta":{"origin":105,"position":1},"title":"On Teaching Children","author":"clay","date":"July 20, 2007","format":false,"excerpt":"Some thoughts as i ponder upon daily incidents with them: ------------------------------ On Cursing\/Dirty Words ------------------------------ A: \"Teacher, B said the F word\" B: \"No!\" T: \"Ok, thank you A for reporting this to me\" T: \"I want you to know 2 things.\" Dirty words is wrong. Second, you don't fear\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":543,"url":"https:\/\/potterdreams.com\/clay\/interest\/holistic-of-holistic\/","url_meta":{"origin":105,"position":2},"title":"Holistic of Holistic","author":"clay","date":"June 26, 2013","format":false,"excerpt":"It's something that I shared with my wife 2 years ago. That time we learnt so many things about the word \"holistic\". From holistic dentistry, holistic healthcare, etc.....Suddenly so many fields claiming to be holistic. And in the essence what they mean with holistic is treating an illness, a patient,\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":111,"url":"https:\/\/potterdreams.com\/clay\/interest\/programmings\/mysql\/","url_meta":{"origin":105,"position":3},"title":"MYSQL","author":"clay","date":"April 5, 2012","format":false,"excerpt":"Note: All these based on MySQL 5.1.61 1.\u00a0Find duplicate entries in table SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; 1b. List Down all the duplicate entries SELECT userid, users.user_ic, useremail, company FROM `users` INNER JOIN (SELECT useric FROM users WHERE useric <> \"\" GROUP BY\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/comments?post=105"}],"version-history":[{"count":0,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/105\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/pages\/103"}],"wp:attachment":[{"href":"https:\/\/potterdreams.com\/clay\/wp-json\/wp\/v2\/media?parent=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}