Hello All,

which formula is required to be written in cell L2 in order to sum all values in rows between C and I columns for each references which are presented more than one as in B column but summarized as in K column in the screenshot in attachment. How about if the references lookup values are in another sheet?