Calculating Overdue Amount

[Bibhuti Mohanty]

Dear All Excel Excerpt,

I want to calculate the overdue amount for my vendor ageing report.
The requirement is automatic calculate the over due as per credit term in relation with vendor code on the overdue column.
For your reference please find out the attached file.

Thanks,

 

[Hui]

Bibhuti

Firstly, Welcome to the Chandoo.org Forums

In your example I would change the values in C1:I1 to 30, 45, 60, 75, 90,999 as per the below


Then in K2:
=SUMPRODUCT(($D$1:$I$1>$C2)*($D2:$I2))
OR
=SUMIFS(D2:I2,$D$1:$I$1,">"&$C2)