All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc