How to get sum of overdue payment based of given credit days period

**devawad** · 12-17-2018, 07:09 AM

Dear All,

I have data In which date wise Invoicing details is given in sheet1 and in sheet2 to customer wise credit period is given.

I want to get only total of overdue payment which crosses the credit period.

For example - Balaji Trading company has 60 credit day. so I want to total amount of all invoice in sheet2 column D that are above sixty days.

Sample sheet attached.

Regards,

Dev.

**PaulM100** · 12-17-2018, 07:21 AM

This should do the trick:

Please Login or Register  to view this content.

**samba_ravi** · 12-17-2018, 07:54 AM

OR
D2=SUMPRODUCT(Sheet1!$E$2:$E$618,--(Sheet1!$A$2:$A$618=$A2),--(--Sheet1!$D$2:$D$618<(TODAY()-$C2)))
Try above and drag towards down

**devawad** · 12-18-2018, 02:16 AM

Dear All,

Thanks, for solution working great.

Dev.

How to get sum of overdue payment based of given credit days period

LinkBack

Thread Tools

Rate This Thread

Display

How to get sum of overdue payment based of given credit days period

Re: How to get sum of overdue payment based of given credit days period

Re: How to get sum of overdue payment based of given credit days period

Re: How to get sum of overdue payment based of given credit days period

Thread Information

Users Browsing this Thread

Similar Threads

Calculate cost based on number of days within a period

Formula that predicts a future date of payment based on an average # of days.

[SOLVED] Credit Card Payoff Optimization Problem with specified loan amount and monthly payment

How to calculate number of sick days taken in a rolling 365 days period based on colour

[SOLVED] Counting the number of days overdue based on date and time

Turn Cell Red when Payment Overdue

Payment of Invoices in comparison with the payment period

Bookmarks

Bookmarks

Posting Permissions