{"id":54235,"date":"2019-05-22T16:13:40","date_gmt":"2019-05-22T15:13:40","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=54235"},"modified":"2021-06-29T15:41:34","modified_gmt":"2021-06-29T14:41:34","slug":"sumquotient-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/sumquotient-in-excel\/","title":{"rendered":"SUMQUOTIENT in Excel"},"content":{"rendered":"<p>V. Bestaat er een SUMQUOTIENT in Excel? Ik gebruik SUMPRODUCT om in een puntenboek rubrieken een verschillend gewicht te geven. Maar nu wil ik het omgekeerde: verschillende maxima, maar de verschillende onderdelen dezelfde verhouding geven.<\/p>\n<p>Dus: in plaats van<\/p>\n<table>\n<tbody>\n<tr>\n<td>MAX<\/td>\n<td>10<\/td>\n<td>10<\/td>\n<\/tr>\n<tr>\n<td>GEWICHT<\/td>\n<td>25%<\/td>\n<td>75%<\/td>\n<\/tr>\n<tr>\n<td>naam<\/td>\n<td>score1<\/td>\n<td>score2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>wil ik<\/p>\n<table>\n<tbody>\n<tr>\n<td>MAX<\/td>\n<td>10<\/td>\n<td>15<\/td>\n<\/tr>\n<tr>\n<td>GEWICHT<\/td>\n<td>50%<\/td>\n<td>50%<\/td>\n<\/tr>\n<tr>\n<td>naam<\/td>\n<td>score1<\/td>\n<td>score2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>A. Ja, er bestaat iets als SUMQUOTIENT: gebruik \/ ipv ; in SUMPRODUCT. Zie bv. <a href=\"https:\/\/www.mrexcel.com\/forum\/excel-questions\/393159-create-sumquotient-formula.html\" rel=\"nofollow\">https:\/\/www.mrexcel.com\/forum\/excel-questions\/393159-create-sumquotient-formula.html<\/a><\/p>\n<p>Echter: die berekening geeft het gemiddelde in plaats van de som.<\/p>\n<p>Ik heb een en ander uitgewerkt in <a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2019\/05\/sumquotient.xlsx\">dit werkblad<\/a>. De beste oplossing lijkt om manueel te delen door het maximum.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Bestaat er een SUMQUOTIENT in Excel? Ik gebruik SUMPRODUCT om in een puntenboek rubrieken een verschillend gewicht te geven. Maar nu wil ik het omgekeerde: verschillende maxima, maar de verschillende onderdelen dezelfde verhouding geven. Dus: in plaats van MAX 10 10 GEWICHT 25% 75% naam score1 score2 wil ik<\/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":[539,78,54,375,79,572,160],"tags":[553],"class_list":["post-54235","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-cvosemper","category-excel","category-excel-office-2010","category-odisee","category-puntenboek","category-tabellen","tag-puntenboek"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 09:28:25","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\/54235","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=54235"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/54235\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=54235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=54235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=54235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}