Hey everyone, I'm new to this platform so I'm just trying my luck :) I've been working on an excel sheet with multiple spreadsheets. The first sheet is a drop-down list based on a chart I created on a separate sheet. Now here is where it gets a little complicated - I'm trying to sum the amounts from the first sheets with the drop-down list on a new spread sheet with a chart that has the same words as the drop down by using the index match function which is very useful. The problem is, that it allow me to sum each word only once, and if I use the same word a second time it wouldn't give me the amount...

Really hope this is clear enough and I will be truly grateful to whom i ever gets back to me.

Thank you all!