# Solved EXCEL: Sum Totals in Drop Down List; Multiple Columns

Microsoft Excel 2010 - complete product...
August 9, 2016 at 13:52:13
Specs: Windows 64
 I'm looking to sum totals in a drop down list as follows:In column C (lines 7 - 38) I have a drop down list that assigns categories to that particular line. In column F (lines 7 - 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've done is assign a number of attendees to a certain category of event. EXAMPLE Instance 1-----Column C (Drop Down Selection): Event Type 1 Column F; Line 7: 42Instance 2----Column C (Drop Down Selection): Event Type 1Column F, Line 8: 66 ** 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 CThere 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 "Event Type 1" category only. I need this to apply to all of column F. The destination box for the sum would be F44.I know this is a SUM or SUMIF function but I'm not sure how to input it into the formula bar. Can anyone help? Again...here's the information:Category Assignment - Column C (Lines C7 - C38)Numerical Value per Incidence - Column F (Lines F7 - F38)Sum Total of Numerical Values per Incidence (Box F44)THANKS!message edited by OmniBartonCreek

See More: EXCEL: Sum Totals in Drop Down List; Multiple Columns

#1
August 9, 2016 at 14:51:08
 A SUMIF() should get you what you want.In it's simplest form something like: =SUMIF(\$C\$7:\$C\$38,"Event Type 1",\$F\$7:\$F\$38)Since your using Drop Downs, you can replace the string "Event Type 1"with the cell location holding that value, so it would look like:=SUMIF(\$C\$7:\$C\$25,\$X\$1,\$F\$7:\$F\$25)Where cell X1 contains your string "Event Type 1"MIKEhttp://www.skeptic.com/

Report •

#2
August 10, 2016 at 08:59:11
 Excellent! This worked perfectly! I'm glad you were able to understand how I explained it because it took me some time to draft it! I really appreciate your help!

Report •
Related Solutions