Sum Ranges in List

[QuestMatt]

Hi All,

I have 4 drop-down lists containing names. I need a formula to add the sums of the selected drop-downs. Each choice in the drop-down is its own named range.

For example, if Drop-Down 1 = John, Drop-Down 2 = Tim and Drop-Down 3 = Henry, is there a formula where I can tell Excel to return the value of the sum of the named ranges John + Tim + Henry??

Thanks in advance!!

[NBVC]

=Sum(John,Tim,Henry)

or

=SUM(INDIRECT(A1),INDIRECT(B1),INDIRECT(C1)) where A1:C1 contain drop down values

[QuestMatt]

Thanks! That's a good start - I should have been more specific.

What I'm trying to do is return 1 of 2 possible values in a table for each named range, based on an additional drop-down.

For example, if drop-down 1 = John, and drop-down 2 = Tim, AND drop-down 5 = Utilization.... Show me the combined utilization for John + Tim for 2002. The next cell would show the same data for 2003, etc.

Any thoughts?

[NBVC]

That definitely does not look like the original question...

Please provide sample workbook showing setup and expected results.