I have SHEET 1 in excel. I call it DAY BOOK.
The day book I enter daily basis for my expenses and incoming fund.
I have SHEET 2 in excel. I call it JOURNAL.
I want to extract from SHEET 1 separate items (e.g. : transportation separate,
stationery separate, food separate etc...). Each Item's total I need total also
as shown in my table. This way I need automatic in SHEET 2.
How to give formula for this? Please comment.
SHEET 1
SHEET 2 for monthly expenses
The day book I enter daily basis for my expenses and incoming fund.
I have SHEET 2 in excel. I call it JOURNAL.
I want to extract from SHEET 1 separate items (e.g. : transportation separate,
stationery separate, food separate etc...). Each Item's total I need total also
as shown in my table. This way I need automatic in SHEET 2.
How to give formula for this? Please comment.
SHEET 1
DATE | PARTICULARS | INCOME RS. | OUTGOING RS |
8-1-2020 | TRANSPORTATION | 1500 | |
8-1-2020 | STATIONERY | | 1200 |
9-1-2020 | FOOD | | 800 |
9-1-2020 | FOOD | | 1600 |
9-1-2020 | PARTY | | 1700 |
10-1-2020 | CHEQUE NO.1245 | 10000 | |
10-1-2020 | STATIONERY | | 500 |
10-1-2020 | COURRIER SERVICES | | 5000 |
11-1-2020 | TOUR | | 3000 |
12-1-2020 | CHEQUE NO.18554 | 4500 | |
13-1-2020 | PARTY | | 2000 |
13-1-2020 | COURRIER SERVICES | | 2000 |
14-1-2020 | COURRIER SERVICE | | 5000 |
SHEET 2 for monthly expenses
PARTICULARS | AMOUNT |
TRANSPORTATION | 1500 |
STATIONERY | 1700 |
FOOD | 2400 |
PARTY | 3700 |
COURRIER SERVICE | 12000 |
|