Daily Expense Tracker

[sanjeev kumar]

Dear Friends,
I have made an Excel sheet to track my daily expenses. Plz find the attached sheet and give me a suggestion to improve this.

 

[Somendra Misra]

Hi Sanjeev,

Personally, I never developed such trackers, all I can say that if it is giving the user all the information in an easy and understood manner it is OK. Become a user and see if it giving you all the related information. Show it to the concerned users of this tracker and ask them, what more they want from this, do they require any type of error checks in it (as it related to finance ). I think the users can give more information how to improve it.

One thing I noticed in SUMIFS formulas you are using full column A:A ref., this will slow down your workbook. Restrict this by dynamic named ranges of Table feature.


Regards,

 

[sanjeev kumar]

Hi Somendra,
Thanks for such a nice advice. I will follow the same.

 

[Debraj]

One thing I noticed in SUMIFS formulas you are using full column A:A ref.

.

Hi Somu..

Just a side note..

SUMIF/S, COUNTIF/S.. are enough capable to handle Full Columns range.. Internally.. its only checks data in Intersect of UsedRange & Provided Range..

 

[Somendra Misra]

@Debraj dada....

I did not knew this.. Thanks for the information dada.

Regards,