Formula for Monthly Journal

[Safa]

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

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​
​

 

[StuLux]

I need clear cut idea about sumif also please.

If you are using a Pivot Table you don;t need the SumIf formula?

 

[Safa]

Sumif formula is so good for me in some cases. I like it very much. Please educate me sbout sumif.

 

[StuLux]

Microsoft provide some very good training material themselves with examples - see following link specifically for SUMIF formulas, also try googling for additional resources.

SUMIF function - Microsoft Support

How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.

support.office.com