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!
/u/Vivid-Carob-4546 - Your post was submitted successfully.
Solution Verified
to close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.