Hi, I am looking to sum a running current month to date total. So end of February it will show total Jan to Feb and end of March will show Jan to March. I've tried a few variations of sumifs & index match but haven't been able to figure it out. Sheet(target est) Col A1 is a join then c-n are Jan- dec data. Sheet (BvA)has the same join info in Col a and a reference date in e5. I need to match the joint Col b/t the 2 sheets then match the date in sheet 2 and total all the data on sheet 2 up to that date. Thanks
Bookmarks