**Question description:**

*This user has given permission to use the problem statement for this blog.*

hi
i need to a formula that once an option in a drop down box is chosen it reads the option and chooses one of the cells to sum up.
thank you

Solved by S. Q. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
15/03/2018 - 08:54

hello?

Excelchat Expert
15/03/2018 - 08:54

HI welcome. Can I ask what the end result you are looking for

Excelchat Expert
15/03/2018 - 08:55

You are looking to use a drop down to change another cell correct?

User
15/03/2018 - 08:55

once a option is chosen in a drop down box it will pick the requested cell info then put it into another cell aling with the sum of the final cell

User
15/03/2018 - 08:55

correct

Excelchat Expert
15/03/2018 - 08:56

What options are you wanting to put in the drop down list?

User
15/03/2018 - 08:56

i have made the drop down already it works good

User
15/03/2018 - 08:56

simple one

Excelchat Expert
15/03/2018 - 08:57

Ok so once you click on the drop down list, you want that to go into another cell?

Excelchat Expert
15/03/2018 - 08:57

like this?

User
15/03/2018 - 08:57

see sheet

Excelchat Expert
15/03/2018 - 08:57

Yes I see it

Excelchat Expert
15/03/2018 - 08:59

So I see those are the drop down options you are wanting?

User
15/03/2018 - 09:00

what you think?

Excelchat Expert
15/03/2018 - 09:00

I am lost what you are trying to accomplish

Excelchat Expert
15/03/2018 - 09:00

You have the drop down list that has the items test, subtotal, tax, and total?

User
15/03/2018 - 09:01

the drop down is the GL codes

User
15/03/2018 - 09:01

then it matches with the GL summary area liek sales call

Excelchat Expert
15/03/2018 - 09:02

Ok so you basically want to do a sum function once you change the selection?

User
15/03/2018 - 09:02

hmm yes

Excelchat Expert
15/03/2018 - 09:03

I guess I need to see what you are trying to accomplish, I am still lost at what you are trying to accomplish

User
15/03/2018 - 09:04

look at the sheet

Excelchat Expert
15/03/2018 - 09:04

Oh sorry I could not see the whole thing

User
15/03/2018 - 09:04

ok

User
15/03/2018 - 09:04

better?

Excelchat Expert
15/03/2018 - 09:04

A lot sorry

Excelchat Expert
15/03/2018 - 09:04

It didnt load for a while

User
15/03/2018 - 09:06

any suggestions

Excelchat Expert
15/03/2018 - 09:06

Can you tell me which cell has the dropdown

User
15/03/2018 - 09:06

E

User
15/03/2018 - 09:07

colum E has all the drop down options

User
15/03/2018 - 09:07

5358
5368
5375
2510

Excelchat Expert
15/03/2018 - 09:08

So you select 5358 from the dropdown and it puts the subtotal where

User
15/03/2018 - 09:08

in c 17

User
15/03/2018 - 09:09

your are on the right path

Excelchat Expert
15/03/2018 - 09:10

Ok so what I did is once you select 5358 or 5368, it sums the total. Is that what you were looking to do? Sorry that I was missing the rest of the file

User
15/03/2018 - 09:10

yes

User
15/03/2018 - 09:11

i need the totals in c17 to c20

Excelchat Expert
15/03/2018 - 09:12

I did that with the sumif function

User
15/03/2018 - 09:12

the totals should be the subtotals in b colum

Excelchat Expert
15/03/2018 - 09:12

I am going to run an example to show you how it works

User
15/03/2018 - 09:12

ok

Excelchat Expert
15/03/2018 - 09:13

I think I understand your problem and have created a working solution, would you agree?

Excelchat Expert
15/03/2018 - 09:14

I am sorry for taking so long to fully understand your problem.

User
15/03/2018 - 09:15

i think so

User
15/03/2018 - 09:15

it works here but not on my excel sheet

Excelchat Expert
15/03/2018 - 09:16

You can download this spreadsheet into excel or are you saying it won't work on there either?

User
15/03/2018 - 09:16

ok i got it

User
15/03/2018 - 09:17

thank you

User
15/03/2018 - 09:17

cheers

Excelchat Expert
15/03/2018 - 09:17

I downloaded it and believe it works

Excelchat Expert
15/03/2018 - 09:17

:)

Excelchat Expert
15/03/2018 - 09:17

Glad I could help

User
15/03/2018 - 09:17

thanks

Excelchat Expert
15/03/2018 - 09:17

You are welcome.

Excelchat Expert
15/03/2018 - 09:17

Have a great day

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*