Dear members,
I have a problem with my excel file. I want to create the sum out of a list for different things when it is activated in the options list.
Example:
Business 1: in option list 1 Germany and Gb is activated. in option list 2 Car and Engine.
Now i want to have the sum for Car from Germany, Car from GB, Engine from Germany, Engine from GB.
I tried a double vlookup with an index formula but it did not work out.
Does anyone know a solution for this?
Thanks in advance
Moritz
Bookmarks