Formula for Vendor Ageing

[Pankaj Arora]

Hi ,

I want to refine Vendor Ageing Data so that net amount can be shown on the date ignoring collection and any payment made further in such matter.
My requirement is marked in yellow colour.

 

[prasaddn]

Hi,

for Col D to H for the rows in yellow.
Have this formula in D6 and copy to H6
=IF(D5>0,SUM($D5:D5),0)

I am sure you might have found solution long back.

Regards,
Prasad DN

 

[Pankaj Arora]

Hi,

for Col D to H for the rows in yellow.
Have this formula in D6 and copy to H6
=IF(D5>0,SUM($D5:D5),0)

I am sure you might have found solution long back.

Regards,
Prasad DN

Thanx a lot for your solution.