{"id":45404,"date":"2014-03-23T10:01:50","date_gmt":"2014-03-23T09:01:50","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=45404"},"modified":"2018-03-08T16:31:47","modified_gmt":"2018-03-08T15:31:47","slug":"cel-leeg-maar-toch-niet","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/cel-leeg-maar-toch-niet\/","title":{"rendered":"Cel leeg maar toch niet"},"content":{"rendered":"<p>V. Ik heb een formule in Excel die in cel iets zet in functie van de inhoud een andere cel, of die ze leeg laat. Iets in de zin van<\/p>\n<p>=IF(A1=&#8221;&#8221;;&#8221;&#8221;;A1)<\/p>\n<p>Maar als ik die cellen ga tellen met COUNTA worden de lege cellen toch niet als leeg gezien. COUNTA telt ze toch..<\/p>\n<p>A. Klopt &#8211; een lege cel is nog iets anders dan een cel met een lege string.<\/p>\n<p>Gebruik<\/p>\n<p>=COUNTA(bereik)-COUNTIF(bereik;&#8221;&#8221;)<\/p>\n<p>(met dank aan Bill Manville &#8211; <a href=\"http:\/\/community.compuserve.com\/n\/pfx\/forum.aspx?webtag=ws-msoffice&#038;nav=messages&#038;tid=17438&#038;tsn=\" rel=\"nofollow\">http:\/\/community.compuserve.com\/n\/pfx\/forum.aspx?webtag=ws-msoffice&#038;nav=messages&#038;tid=17438&#038;tsn=<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb een formule in Excel die in cel iets zet in functie van de inhoud een andere cel, of die ze leeg laat. Iets in de zin van =IF(A1=&#8221;&#8221;;&#8221;&#8221;;A1) Maar als ik die cellen ga tellen met COUNTA worden de lege cellen toch niet als leeg gezien. COUNTA<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[79,10,246,391],"tags":[],"class_list":["post-45404","post","type-post","status-publish","format-standard","hentry","category-odisee","category-office","category-office-2010","category-office-2013"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 22:54:24","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=45404"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45404\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=45404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=45404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=45404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}