Adding multiple numbers from a list

[KlayColgrove]

I currently have a table that has 2 categories, Budget and Amount. As seen below.

I have Data Validation with a list of all the names for Budget. Under that I have Budget amount that will show the corresponding amount for the selected budget.

QUESTION: I want to be able to select multiple budgets and have the total amount under it. I currently already have the code to select multiple options in the list, but when I do select more than one budget I get an error in the budget amount.


Budget...…. Amount
Coke Q1.... 1250000
Coke Q2...….. 50000
Coke Q3...... 750000
Coke Q4...... 852000

(Budget Amount) =SUM(VLOOKUP(D12,N24:O54,2,FALSE))

So the Budget Name line shows something like: Coke Q1, Coke Q2
Budget Amount then shows the error: #N/A
[TABLE="width: 184"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[James006]

Hello,

You say:

I currently already have the code to select multiple options in the list

1. What is it ...?

2. Why not using this 'mysterious' code for a simple sumproduct...?

 

[KlayColgrove]

I figured out the solution using: =SUMPRODUCT(--ISNUMBER(SEARCH($N$24:$N$53&",",D12&",")),$O$24:$O$53)

 

[James006]

Glad you could fix your problem ...:wink: