Agewise analysis

sailaja (article assistant) (64 Points)

09 June 2015

can anyone please say me what formula i should use for doing agewise analysis of debtors in excel sheet....???

Reply
Follow
Share

2 Replies

Vijayabharathi K (CMA - Job) (32 Points)
Replied 09 June 2015

Hi Sailaja,

If you have ageing details in your report and if you need to categorize the ageing in difference bucket, you can use the below formula :

0-30 : sumifs(amount column,ageing column,"<=30")

31-60 : sumifs(amount column,ageing column,">30",ageing column,"<=60")

...................

Like above, you can add ageing bucket as per your requirement by using sumifs formula.

Hope the above will provide answer for your query.

1 Like

sailaja (article assistant) (64 Points)
Replied 17 June 2015

thank u bharati,,it has been very useful!!

Start a New Discussion