Hello,
I occurred a problem with a sum/match function, which I thought, would be right. Unfortunately when I pressed enter to finish the formula excel told me it has an error and pointed me to the part with connection to the cell with a date that I was referring to.
I have attached a sample book and here is a code that I used in cell F28.
If anyone knows what to change please let me know so I understand where I have done a mistake and which direction I shall go in.
What I am trying to achieve is to match the last received date with the deliveries over last two weeks and first check if it is before the start of the current week. If so the I want it to compare with the deliveries date and sum all the deliveries from the next vehicle than the one that is shown on the left in the table (column E) to the end of that previous week. If it is in the current week I want deliveries from the beginning of the current week to the vehicle stated in the column E to be added to the arrears from sheet 1 column C.
I have managed to include the stated vehicle number in the sum if the last delivery is in previous week but I don’t know how to exclude it. I also don’t know if that sum function is right with all those match arguments.
Anyone with an idea of how to fix it, please help.
I am cracking my head over it.
Thanks for having a look
Bookmarks