sumifs or sumproduct with the month and year given on different cell

[mark692]

on cell f7 on ISBS sheet i want to put a formula that will give me the sum of column D if the year and month is same on cell f5 and cell F6 of ISBS sheet


Excel 2013/2016

	F
2
3
4
5	2018
6	January
7

<tbody>
</tbody>

IS BS​

Excel 2013/2016

	B	C	D
16	date	17-Oct Acquisition useful life 60 months	Total Machineries Depreciation
17	10/30/2017	12,143.46	12,143.46
18	11/30/2017	12,143.46	12,143.46
19	12/30/2017	12,143.46	12,143.46
20	01/30/2018	12,143.46	12,143.46
21	02/28/2018	12,143.46	12,143.46
22	03/30/2018	12,143.46	12,143.46
23	04/30/2018	12,143.46	12,143.46
24	05/30/2018	12,143.46	12,143.46
25	06/30/2018	12,143.46	12,143.46
26	07/30/2018	12,143.46	12,143.46
27	08/30/2018	12,143.46	12,143.46
28	09/30/2018	12,143.46	12,143.46
29	10/30/2018	12,143.46	12,143.46
30	11/30/2018	12,143.46	12,143.46
31	12/30/2018	12,143.46	12,143.46
32	01/30/2019	12,143.46	12,143.46

<tbody>
</tbody>

Lapsing Schedule​

 

[FormR]

Hi, you could try:

=SUMIFS($D$17:$D$32,$B$17:$B$32,">="&F6&F5,$B$17:$B$32,"<="&EOMONTH(F6&F5,0))

 

[Aladin Akyurek]

It would be helpful if you also had posted the expected sum value.

In F7 enter:

=SUMIFS(D17:D32,B17:B32,">="&1&F6&F5,B17:B32,"<="&EOMONTH(1&F6&F5,0))

 

[mark692]

the expected sum value is 12,143.46 from D20 because the date on B20 is january 30 2018


BTW thanks guys your formula work!!

 

[FormR]

the expected sum value is 12,143.46 from D20 because the date on B20 is january 30 2018

Hi, did you try either suggestion?

 

[mark692]

Hi, did you try either suggestion?

yes sir! thanks you so much!