Hy,
I need some help with a raport. The raport needs to show the amount of payments depending on the due date of the month. The result needs to be grouped by inervals
Days 1-7 of the month
? Days 8-14 of the month
? Days 15-21 of the month
? Starting with the 22nd of the month
30,772 rows... rather more than the 10-20 rows we'd like to see.
=SUMPRODUCT((DAY($A$2:$A$31000)>=D2)*(DAY($A$2:$A$31000)<=E2)*$B$2:$B$31000)
copied down. See file.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks