kindly see the attached file, i had tried to evaluate data using sum product, index & match function but not successful. it is the same sheet on which Jacc & others had helped me out but now again struck in middle.
i have shown desired result & seeking a formula to calculate after looking & match values from another data sheet.
Bookmarks