Question.xlsx
In the attached spreadsheet, I need a formula to make column "D" return the given values. Basically, as I have it now, column "C" is able to "Count" the # of payments in any given week. The problem arises when a date in column "A" occurs in the same week but is chronologically before a date in a "higher up" cell in column "A" but in the same week. I.E. Payment on 4/22/13 on row 11 is counted after the payment on 4/26/13 on row 9. I need column "D" to count the payment on 4/22/13 before the payment on 4/26. Any help would be appreciated
Thanks,
Cooper
Bookmarks