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

<tbody>
</tbody>

DATE	EXPENSE NAME	AMOUNT
05/09/2018	STATIONARY	1500
05/09/2018	FANCY	200
06/09/2018	FOOD	450
07/09/2018	GAMES	100

<tbody>
</tbody>

CHART - 2
A B C

CELL	DATE	AMOUNT
1	05/09/2018	10,000
2	07/09/2018	550
3	15/10/2018

<tbody>
</tbody>

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