Sumproduct dates

[tutv088]

Hi All,
I work for a non profit organization and helping them setup a budget workbook and getting totals for . Any help would be appreciated. I'm trying to sum of the totals based on dates that have a criteria which is the Employee ID. My goal is to get a formula for the total of Employee #20012 for the date ranges of 01/01/18 through 3/01/18 in program Orchard. Thanks again and please let me know if you need any clarifications. The answer in the cell should be $1,321

A	B	C	D	E	E		F
Employee ID	01/01/18	2/01/18	3/01/18	4/01/18	Program		Total
20012	$543	$233	$545	$432	Orchard		????
20012	$452	$362	$263	$556	YS
20034	$112	$223	$332	$123	Lay

<tbody>
</tbody>

 

[Aladin Akyurek]

=SUM(B2:D2)

would suffice.

 

[Aladin Akyurek]

Or you have something like this in mind...

Book1
	A	B	C	D	E	F	G	H	I	J
1	Employee ID	1/1/2018	2/1/2018	3/1/2018	4/1/2018	Program				1/1/2018
2	20012	$543	$233	$545	$432	Orchard				3/1/2018
3	20012	$452	$362	$263	$556	YS		20012	Orchard	$1,321
4	20034	$112	$223	$332	$123	Lay
Sheet1

In J3 control+shift+enter, not just enter:

=SUM(IF($A$2:$A$4=H3,IF($F$2:$F$4=I3,IF($B$1:$E$1>=J$1,IF($B$1:$E$1<=J$2,$B$2:$E$4)))))

 

[tutv088]

Hi Aladin and thanks for the reply hahhaa. Yes, that would suffice but would you know of a formula because there will be hundreds of rows and with different employees and the dates will have to cover more months down the road and I want to automate as much as possible. Maybe I am over thinking it. I appreciate the help brotha.

 

[tutv088]

Ok ill try this tonight. Thank You