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...
Hi Mathetes,
Thank you for asking, you can access the case on this file https://bdfgrp-my.sharepoint.com/:x:/r/personal/muhammadreza_nugraha_external_beiersdorf_com/Documents/Documents/TES%20DATA%20STOCK.xlsx?d=w0501dd1caaf04e45950339e0127abf03&csf=1&web=1&e=Dzcs6S
My goal is trying to sum and match every single date on formatted summary with other criterias since on raw data tab the dates are not sequential, as additional i want to minimize the effort to match the different column date on raw data by selecting all column and row to be sum (so i dont need to change manually the column later)
can you help me to check on this formula or there's any other alternative to pull this data?