My mistake. Try this (in I10 and copy down):
I'm curious:
1) on sheet '2016', why is the week of 1/29/2016 part of FEBRUARY? If it belongs, then why does 2/26/2016 ALSO belong?
2) cell K10, the RED section (expression-expression) always = 0. What is your intent?
=IF(ISBLANK($B10),"",IF(AND($J10>=$A$1,$J10<=$A$3),OFFSET('2016'!$A$4,MATCH($M10,'2016'!$A:$A,0)-4,MATCH('Invoice Summary'!$J10,'2016'!$J$5:$AE$5,0)+9,1,MATCH("Amount Paid",'2016'!$J$8:$AE$8,0)-MATCH("Amount Paid",'2016'!$J$8:$AE$8,0)+1),""))
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Bookmarks