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: 42
Instance 2—-
Column C (Drop Down Selection): Event Type 1
Column 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 C
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 “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
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”
MIKE
http://www.skeptic.com/