{"id":15081,"date":"2021-12-17T15:57:34","date_gmt":"2021-12-17T15:57:34","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=15081"},"modified":"2021-12-17T15:57:52","modified_gmt":"2021-12-17T15:57:52","slug":"solved-excel-sum-totals-in-drop-down-list-multiple-columns","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-sum-totals-in-drop-down-list-multiple-columns\/20484.html","title":{"rendered":"Solved EXCEL: Sum Totals In Drop Down List; Multiple Columns"},"content":{"rendered":"<p>I&#8217;m looking to sum totals in a drop down list as follows:<\/p>\n<p>In column C (lines 7 &#8211; 38) I have a drop down list that assigns categories to that particular line. In column F (lines 7 &#8211; 38) there are totals that apply to that particular line item that are numbers. These totals change with each instance of a particular category. Essentially what I&#8217;ve done is assign a number of attendees to a certain category of event.<\/p>\n<p><b>EXAMPLE <\/b><br \/>\n<i>Instance 1&#8212;&#8211;<\/i><br \/>\nColumn C (Drop Down Selection): Event Type 1<br \/>\nColumn F; Line 7: 42<\/p>\n<p><i>Instance 2&#8212;-<\/i><br \/>\nColumn C (Drop Down Selection): Event Type 1<br \/>\nColumn F, Line 8: 66<\/p>\n<p><b>** What I need is a formula that will sum the total in all of Column F of all instances of Event Type 1 when selected as the drop down item in Column C<\/b><\/p>\n<p>There would be about 6 or 7 incidences per spreadsheet and I need a sum of the total numbers associated with each category. In the above example I would need a formula that added the totals in F7 and F8 when associated with the &#8220;Event Type 1&#8221; category only. I need this to apply to all of column F. The destination box for the sum would be F44.<\/p>\n<p>I know this is a SUM or SUMIF function but I&#8217;m not sure how to input it into the formula bar. Can anyone help? Again&#8230;here&#8217;s the information:<\/p>\n<p>Category Assignment &#8211; Column C (Lines C7 &#8211; C38)<br \/>\nNumerical Value per Incidence &#8211; Column F (Lines F7 &#8211; F38)<br \/>\nSum Total of Numerical Values per Incidence (Box F44)<\/p>\n<p>THANKS!<\/p>\n<p align=\"right\"><span style=\"font-size: xx-small;\"><i>message edited by OmniBartonCreek<\/i><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":29},"question-category":[53],"question_tags":[],"class_list":["post-15081","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/15081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=15081"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=15081"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=15081"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=15081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}