I'm trying to do this thing on Excel where I have a list of values that
are being summed at the bottom of the page. Thats not a problem. The
problem I'm having is that one of the cells is a pull down list
(Validation) and I need to set it up so each of the choices (eg. A-1,
B-2,...) has a specific value associated with it that will be added in
with the rest of the sum. Anyone know how I can do this?


--
AlwaysAAngel
------------------------------------------------------------------------
AlwaysAAngel's Profile: http://www.excelforum.com/member.php...o&userid=27284
View this thread: http://www.excelforum.com/showthread...hreadid=467915

A-1
B-2
are not cell addresses (A1 or B1), are they?

And if you have quite a few of these, it might be best to set up a table (on
another worksheet) that has the values that correspond to these choices.

A-1 5
B-2 17
c-3 39
'etc

Then you can use =vlookup() in a nice adjacent cell (or embedded into the
formula) to return that value:

=if(c9="",0,vlookup(c9,sheet2!a:b,2,false))
(C9 is my cell with data|validation.)

Then you can use:
=sum(c2:c8,d9,c10:c99)

to add them up.
(c2:c8 & c10:c99 are just numbers, d9 held that =vlookup() formula)

For more info about =vlookup()...
You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

AlwaysAAngel wrote:

I'm trying to do this thing on Excel where I have a list of values that
are being summed at the bottom of the page. Thats not a problem. The
problem I'm having is that one of the cells is a pull down list
(Validation) and I need to set it up so each of the choices (eg. A-1,
B-2,...) has a specific value associated with it that will be added in
with the rest of the sum. Anyone know how I can do this?

--
AlwaysAAngel
------------------------------------------------------------------------
AlwaysAAngel's Profile: http://www.excelforum.com/member.php...o&userid=27284
View this thread: http://www.excelforum.com/showthread...hreadid=467915

--

Dave Peterson