sumifs the date within the given year

[mark692]

Book1
	A	B	C	D
1	Year	2017
2
3	Date	DR	SI	Amount
4	01/28/2016	123		20.00
5	01/23/2016	456		50.00
6	02/28/2017		333	30.00
7	03/17/2017	789		50.00
8	04/15/2017		444	10.00
9
10	ANSWER	40.00
Sheet1

hi guys is there a formula for there i want to know the sum of column D with this fallowing criteria

1. year of the given date on column A has the same year on cell B1
2. column C has a value greater than zero


thanks

 

[steve the fish]

Try like this:

=SUMIFS(D4:D8,A4:A8,">="&DATE(B1,1,1),A4:A8,"<"&DATE(B1+1,1,1),C4:C8,">0")