can anyone please say me what formula i should use for doing agewise analysis of debtors in excel sheet....???
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.
sailaja
(article assistant)
(64 Points)
Replied 17 June 2015
thank u bharati,,it has been very useful!!
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
CAclubindia
