{"id":62108,"date":"2023-03-25T10:30:34","date_gmt":"2023-03-25T09:30:34","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=62108"},"modified":"2023-03-25T10:31:44","modified_gmt":"2023-03-25T09:31:44","slug":"vragen-met-meerdere-antwoorden","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/vragen-met-meerdere-antwoorden\/","title":{"rendered":"Vragen met meerdere antwoorden"},"content":{"rendered":"

V. Ik heb in deze enqu\u00eate een vraag waarop mensen meerdere antwoorden tegelijk kunnen geven. Maar in draaitabellen geeft dat niet wat ik wil. Is er een oplossing?<\/p>\n

A. Met draaitabellen ga je het aantal keer tellen dat er een bepaalde combinatie voorkomt. Bijvoorbeeld:<\/p>\n\n\n\n\n\n\n\n
Wat eet je graag?<\/td>\n<\/tr>\n
pizza<\/td>\n<\/tr>\n
pizza,pasta<\/td>\n<\/tr>\n
pasta,ijs<\/td>\n<\/tr>\n
ijs<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Als je wil tellen hoe dikwijls een van de antwoorden voorkomt, kan je dat zo doen<\/p>\n\n\n\n\n
Bereiding<\/td>\nAantal<\/td>\n<\/tr>\n
Pizza<\/td>\n=AANTAL.ALS(A:A;”*”&I2&”*”)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Meer info nodig? Lees dan bv.<\/p>\n

How to Count Cells that Contain Text Strings in Excel<\/em>
\nhttps:\/\/trumpexcel.com\/count-cells-that-contain-text\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

V. Ik heb in deze enqu\u00eate een vraag waarop mensen meerdere antwoorden tegelijk kunnen geven. Maar in draaitabellen geeft dat niet wat ik wil. Is er een oplossing? A. Met draaitabellen ga je het aantal keer tellen dat er een bepaalde combinatie voorkomt. Bijvoorbeeld: Wat eet je graag? pizza pizza,pasta<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":8,"footnotes":""},"categories":[538,54,375,79,10,246],"tags":[],"class_list":["post-62108","post","type-post","status-publish","format-standard","hentry","category-enquetes","category-excel","category-excel-office-2010","category-odisee","category-office","category-office-2010"],"publishpress_future_action":{"enabled":false,"date":"2026-05-05 13:37:05","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\/62108","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=62108"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/62108\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=62108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=62108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=62108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}