Summing Values from a drop downlist

**AJHANSEN77777** · 09-19-2018, 03:41 AM

Morning,

I've set up and expense sheet for our sales team. I've created a drop down list for each purchase they make so that it can be posted to the correct nominal. I.e. easyjet flight goes in the description then the sales person selects flights from the drop down list.

How do I then get the value entered by the sales person to appear on a separate worksheet? can I create a formula so that everytime "flight" is chosen from the drop down list it sums them all on a separate worksheet?

Basically want to make my life easier rather than posting all lines on an expense sheet to our nominal ledger and instead just putting them as a lump sum.

Andy

**Glenn Kennedy** · 09-19-2018, 03:49 AM

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

**AJHANSEN77777** · 09-19-2018, 04:02 AM

hi Glenn,

thanks for the quick response. I've just attached the spreadsheet and tried to follow your instructions.

I just need the net values to total on the worksheet titled Nominal analysis.

**Glenn Kennedy** · 09-19-2018, 04:07 AM

Try this:

=SUMIF('Expense Sheet'!D:D,B2,'Expense Sheet'!G:G)

in C2 of Nominal Analysis.

**AJHANSEN77777** · 09-19-2018, 04:12 AM

Glenn, you're a star.

Could you just explain what Excel is doing to get the values? Just so I can understand it better

**Glenn Kennedy** · 09-19-2018, 04:16 AM

=SUMIF('Expense Sheet'!D:D,B2,'Expense Sheet'!G:G)

Yellow: look in this column for all values that match
Orange: this value
Blue: and then sum the corresponding values in this column.

**AJHANSEN77777** · 09-19-2018, 04:23 AM

Thanks Glenn.

Summing Values from a drop downlist

LinkBack

Thread Tools

Rate This Thread

Display

Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Re: Summing Values from a drop downlist

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Any Formula solution for summing corresponding values in other column against top 5 values

Summing with Validation drop down lists

Error with Dependant Drop downlist (using INDIRECT function)

[SOLVED] Summing numbers across drop-down lists

Help! Calulation based upon a drop downlist??

Summing Amounts by Drop Down List Selection

Summing matrix values based on X & Y axis values

Bookmarks

Bookmarks

Posting Permissions