Finding the sum value between two date

[rameshppc]

HI GOOD EVENING...

I HAVE EXPENSES CHART WITH DATE WISE DATA. I NEED TO PUT THE SUM VALUE OF EXPENSES FROM ONE DATE TO ANOTHER AND ALSO THE FROM AND TO DATE WILL BE VARY FOR THE ADJUSTMENT CELLS.

CHART - 1

[TABLE="width: 500"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]DATE
[/TD]
[TD]EXPENSE NAME
[/TD]
[TD]AMOUNT
[/TD]
[/TR]
[TR]
[TD]05/09/2018
[/TD]
[TD]STATIONARY
[/TD]
[TD]1500
[/TD]
[/TR]
[TR]
[TD]05/09/2018[/TD]
[TD]FANCY
[/TD]
[TD]200
[/TD]
[/TR]
[TR]
[TD]06/09/2018
[/TD]
[TD]FOOD
[/TD]
[TD]450
[/TD]
[/TR]
[TR]
[TD]07/09/2018
[/TD]
[TD]GAMES
[/TD]
[TD]100
[/TD]
[/TR]
</tbody>[/TABLE]

CHART - 2
A B C
[TABLE="width: 500"]
<tbody>[TR]
[TD]CELL
[/TD]
[TD]DATE
[/TD]
[TD]AMOUNT
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]05/09/2018
[/TD]
[TD]10,000
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]07/09/2018
[/TD]
[TD]550
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]15/10/2018
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


PLS SEE THE CHART - 2, I WILL FILL THE DATE COLUMN MANUALLY, THE AMOUNT COLUMN NEED TO GENERATE AS BELOW

"C2" = EXPENSES CALCULATE FROM 06/09/2018 TO 07/09/2018
"C3" = EXPENSES CALCULATE FROM 08/09/2018 TO 15/10/2018

KINDLY ADVISE...

 

[Peter_SSs]

See if this, copied down is what you want.

Excel Workbook
	A	B	C
1	DATE	EXPENSE NAME	AMOUNT
2	5/09/2018	STATIONARY	1500
3	5/09/2018	FANCY	200
4	6/09/2018	FOOD	450
5	7/09/2018	GAMES	100
6	7/09/2018		100
7	7/09/2018		300
8	10/09/2018		250
9	11/09/2018		400
10	20/10/2018		100
11
12	DATE	AMOUNT
13	5/09/2018	950
14	7/09/2018	650
15	15/10/2018
16
Sumifs

BTW, the forum prefers that you do not use all upper case letters when making posts. refer to #14 of the Forum Rules

 

[rameshppc]

Thanks a lot for your perfect formula..

Its working awesome..

I want to learn from your below formula...
=IF(A14="","",SUMIFS(C$2:C$10,A$2:A$10,">"&A13,A$2:A$10,"<="&A14))

can you pls explain that, How do the "" works in this formula?

 

[Peter_SSs]

Thanks a lot for your perfect formula..

You're welcome.

I want to learn from your below formula...
=IF(A14="","",SUMIFS(C$2:C$10,A$2:A$10,">"&A13,A$2:A$10,"<="&A14))

can you pls explain that, How do the "" works in this formula?

I'm not certain which inverted commas you are asking about - the ones near the start of the formula of the ones in the green section?

For some general information about SUMIFS & its syntax, here are a couple of references.
https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
https://exceljet.net/excel-functions/excel-sumifs-function