Dear all,
Maybe a simple question, but I can't figure out what goes wrong. I want to sum a list of values based on a match. I attached an example. For one reason, the function SUM(INDEX,MATCH) only adds the first value in the list. I tried SUMIF, SUMIFS, SUM(MATCH) etc. but nothing seems to work. Any idea what I do wrong here? Thanks in advance for the help.
Bookmarks