Sum Date Range Multiple Criteria Over Zero

[tsroque]

Hey Guys!

I need to SUM up the total TYPES by date range (state date / end date), IF it matches two Types AND over $0.00

Sheet 1
A5: START DATE
B5: END DATE
C5: TOTAL OF ALL TYPES LISTED RECEIVED OVER $0.00 BETWEEN TWO DATES ABOVE

Sheet 2
COLUMN A: Dates Listed
COLUMN E: Type Listed (need "TypeA" and "TypeB" only)
COLUMN H: Amount Listed

I hope I gave enough details... :\

Thank you!

 

[Anand Sharma]

I have done working for you, update formula according to your need, hope this would help you

Start	End	Type	Amount	FormulaCell	Formula
11/1/2016	11/2/2016	A	10	30	SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A12,$A$12:$A$15,"<"&B12,$C$12:$C$15,"A")+SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A12,$A$12:$A$15,"<"&B12,$C$12:$C$15,"B")
11/2/2016	11/3/2016	B	20	20	SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A13,$A$12:$A$15,"<"&B13,$C$12:$C$15,"A")+SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A13,$A$12:$A$15,"<"&B13,$C$12:$C$15,"B")
11/3/2016	11/4/2016	C	10	20	SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A14,$A$12:$A$15,"<"&B14,$C$12:$C$15,"A")+SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A14,$A$12:$A$15,"<"&B14,$C$12:$C$15,"B")
11/4/2016	11/5/2016	B	20	20	SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A15,$A$12:$A$15,"<"&B15,$C$12:$C$15,"A")+SUMIFS($D$12:$D$15,$A$12:$A$15,">"&A15,$A$12:$A$15,"<"&B15,$C$12:$C$15,"B")

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>