Drop down to include or exclude a value in another cell.

[Ravanos]

What im trying to do is have a drop down box with A, B,C options in it ( i know how to do this part ), then would have an open cell to inter in numbers and have that value be added to another cell depending on the A,B, or c.

So for example

A1 b1______________ Total for A Total for B Total for C
B $45 ______________ $55______ $45______ $35
A2 b2
C $20
A3 B3
C $15
A4 B4
A $55

Im sorry if this was asked before but ive been searching for hours trying to get this done. Thank you in advance for any help that is given.

 

[WarPigl3t]

I put your dataset in a real table so it's easier to read

	A	B	C	D	E
1	B	45	55	45	35
2	C	20
3	C	15
4	A	55

<tbody>
</tbody>

Now you said that the A column holds the drop down lists. There are 3 values in the drop down list(A, B, C). In column B is a blank cell where the user will input a number. Then you said that that number that is added by the user in column B gets added to another number, but you didn't say which number it gets added to and it doesn't show in your dataset. So cell B1 says 45. In cell A1, B was selected from the drop down list. So 45 plus what equals 55 in cell C1? How do you get that result?

 

[Ravanos]

I'm sorry my post was a little confusing i will try to clear things up. C1 is the total for any A's selected, D1 is the total for any B's selected and E1 is for any C's that are selected. For example , In A3 i have 15 units of product C (B3 ) so with B2 and B3 added together i get 35 in E1. So if i change A3 to product B i now have D1 as 60 units and E1 falls to 20 Units. I'm trying to get so when i choose a drop down in column A ( ether product A,B,C ) determines where the numbers in column B will be added to so i get a total of each in column. I hope that clears it up.

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this formula, copied across, do what you want?
The ranges for columns A & B will need to be (at least) as big as your data is (or is ever likely to be).

Excel Workbook
	A	B	C	D	E
1			Total	Total	Total
2			A	B	C
3	B	45	55	45	35
4	C	20
5	C	15
6	A	55
7
Ravanos

 

[Ravanos]

Ive tried that formula but it won’t change value if A goes to B. I may just have to rethink my layout for the spreadsheet

 

[WarPigl3t]

That's weird because Peter's formula should definately of worked. I think you missed something. Did you make your table look like his?

 

[Peter_SSs]

Did you make your table look like his?

In particular, do you have the A, B, C in cells by themselves like I have in row 2?

If you do have/need the headings to be like your original sample, then try like this.

Excel Workbook
	A	B	C	D	E
1			Total for A	Total for B	Total for C
2	B	45	55	45	35
3	C	20
4	C	15
5	A	55
Ravanos

 

[Ravanos]

That Worked! I think i messed up a cell with the other tried. Thank your very much for your help!