Hello all, I've attached an example file because I think what I want is complicated, though I'm hoping not.
What I want is to calculate the deposits that occurred for specific month that excludes deposits made in a different month even if the project was completed in that specific month.
So if several projects were completed in February (across 4 different weeks in February), and most were paid out in February, I want to exclude the amount paid out in March (even though the project was completed in February). And I only want to sum up the amount, not the % completed or the date. This information is in a row and it's not my spreadsheet. And the % completed, the amount and the date are required.
In the example provided, for the first ID #, 234, the total February deposit should be $90, excluding the $50 paid out in March for February (Week 4).
Thanks
Marby
What I want is to calculate the deposits that occurred for specific month that excludes deposits made in a different month even if the project was completed in that specific month.
So if several projects were completed in February (across 4 different weeks in February), and most were paid out in February, I want to exclude the amount paid out in March (even though the project was completed in February). And I only want to sum up the amount, not the % completed or the date. This information is in a row and it's not my spreadsheet. And the % completed, the amount and the date are required.
In the example provided, for the first ID #, 234, the total February deposit should be $90, excluding the $50 paid out in March for February (Week 4).
Thanks
Marby