Sum of Value overlap dates criteria

Dear Excel Expert,

My problem,
based on long term contract data with start date, end date and monthly revenue (be simplified),
how I summarize with a choice of monthly periods (2, 3, 4, 6 months & yearly)?

Start End Monthly
1/4/16 31/3/20 1.000

Criteria Option
Start : 1/1/16, End : 31/3/16 ( 3months period) or
Start : 1/1/16, End : 30/4/16 ( 4months period), etc..

The following sample data attachment,

I only figure out monthly periods

Formula:

=SUMPRODUCT((DATA!$G$4:$G$10)*$E$2;--(DATA!$C$4:$C$10<=E8);--(DATA!$E$4:$E$10>=E9);--(($E$4="*")+(DATA!$A$4:$A$10=$E$4));--(($E$5="*")+(DATA!$B$4:$B$10=$E$5)))/$E$3

Thank you very much in advance
qFreud