Forum Discussion
SUM WITH INDEX MATCH ERROR
so i want to sum all of possibility based on criteria to search value that i've adjust. the goal is to create dynamic formula that dont need to adjust per column (that's why i adjust the range formul...
If I understand the goal correctly, you might use:
=SUM(IF((month = C13) * (Date = C14) * (Branch = C15) * (item = C16), val, 0))The attached workbook uses conditional formatting to highlight the values meeting the criteria so you can verify results.