Date Wise total Expense track

[sanjeev kumar]

Hi,

I want track date wise expenses.

---------------------------------------------
Date Particular Amount
---------------------------------------------
1-6-14 Home Rs. 300
1-6-14 Personal Rs. 500
1-6-14 Travelling Rs. 150

2-6-14 Home Rs. 350
2-6-14 Personal Rs. 140
2-6-14 Travelling Rs. 160
2-6-14 Misc Rs. 230

3-6-14 Home Rs. 150
3-6-14 Travelling Rs. 150
----------------------------------------------

I want to know the date wise expense like--
----------------------------------------------------------------
Date Home Travelling Personal Misc
----------------------------------------------------------------
enter date Rs. ? Rs. ? Rs. ? Rs. ?
enter date Rs. ? Rs. ? Rs. ? Rs. ?
----------------------------------------------------------------
Total enter Rs. ? Rs. ? Rs. ? Rs. ?
------------------------------------------------------------

 

[srinidhi]

Hi,

The updated file is attached, please use the sumifs formula & use the dates in all rows.

 

[sanjeev kumar]

Thank you very much.