SUMIFS or SUMPRODUCT with 2D data table and vector criteria

[boozers]

Long-time lurker, first time poster. I've read FAQs, and searched, but suspect I'm using the wrong search terms.

I've got a table with two dimensional data. Dates, monthly, along the top by column. Projects, including start date, along the left, by row. I'm trying to SUMIFS the data, such that I only want positive values and prior to a date in a reference cell. A link to OneDrive example sheet is below but I'll also try showing an example here:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]4/30/19[/TD]
[TD]5/31/19[/TD]
[TD]6/30/19[/TD]
[TD]7/31/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/30/19[/TD]
[TD](425)[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/31/19[/TD]
[TD][/TD]
[TD](1244)[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/30/19[/TD]
[TD][/TD]
[TD][/TD]
[TD](2182)[/TD]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/31/19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD](56)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The (56) in the 7/31/19:7/31/19 cell is the sum of all positive figures above and prior to 7/31/19

The formulas I've tried for this look like this: SUMIFS($b$2:$z4,$b$2:$z4,">0",$b$2:$z$2,"<"&$a5) or SUMPRODUCT(--($b$2:$z$2<$B15),--($b$2:$z4>0),$b$2:$z4)

I'm indifferent between a SUMIFS solution or SUMPRODUCT solution, but the only way I've been able to avoid a #VALUE error is by removing the date condition and manually adjusting the columns I'm summing.

Thanks in advance and apologies if I broke protocol or did a poor job of explaining.

https://1drv.ms/x/s!Ajx8pq4MoHlScLyCjceXZYB3VlQ

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you want
=SUMPRODUCT(($E$5:$EG$5<$B15)*($E$6:$EG14>0),$E$6:$EG14)

 

[boozers]

Thanks very much - that did the trick.

 

[Fluff]

You're welcome & thanks for the feedback