Forum Discussion
SUM WITH INDEX MATCH ERROR
Could you try again to explain what you're trying to do? And better than an image, if you could attach the actual file (or provide a link to OneDrive or some other repository), we could provide a working example of whatever solution.
But it's not clear from your description what you want the sum to be in cell D19, and what the criteria are, or how you want to be able to change things dynamically. So give a few examples of what you mean.
Hi Mathetes,
Thank you for asking. So, ive summarized my case into 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=pVsI62
As you can see on raw data format file, the dates are not sequential. my goal is to match all of the sequential date & month column and and detail rows in formatted summary tab by using those previous formula to sum all column (so i dont need to adjust manually the column based on formatted date)