HI all,
I have a spreadsheet that I extract from Our Asset system, I use this to measure the performance of the procurement team, and its time consuming adding the things up manually. I use a lookup list to find the information in the worksheet, but i would like to calculate automatically the total count of items that fall into the 5 days overdue, 10 days overdue, 15 days overdue, 20 days overdue, 25 days overdue, 30 days overdue, 60 days overdue and 90+ days overdue, all measurred from the last weekending date as shown in the sheet. I just cannot get my head around this formula. Please can someone help me. See the attachment
EAM Procrement MRO Status.xlsx
Bookmarks