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[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD][/TD]
[TD]F

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee ID[/TD]
[TD]01/01/18[/TD]
[TD]2/01/18[/TD]
[TD]3/01/18[/TD]
[TD]4/01/18
[/TD]
[TD]Program[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20012[/TD]
[TD]$543[/TD]
[TD]$233[/TD]
[TD]$545[/TD]
[TD]$432[/TD]
[TD]Orchard[/TD]
[TD]
[/TD]
[TD]????[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20012[/TD]
[TD]$452[/TD]
[TD]$362[/TD]
[TD]$263[/TD]
[TD]$556[/TD]
[TD]YS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20034[/TD]
[TD]$112[/TD]
[TD]$223[/TD]
[TD]$332[/TD]
[TD]$123[/TD]
[TD]Lay[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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