I am looking for an excel

__formula__(for Excel 2010) where the user simply enters information in certain cells, and another cell completes SUMIF to calculate the sum of this criteria.

For example

A1: Contains the SUMIF formula

B1: Contains a START DATE as entered by the user (e.g. 01/01/2016)

B2: Contains an END DATE as entered by the user (e.g. 31/12/2016)

C1: Contains a SHEET NAME as entered by the user (e.g. Sheet2)

D1: Contains a START CELL REFERENCE as entered by the user for a sum range (e.g. G1)

D2: Contains an END CELL REFERENCE as entered by the user for a sum range (e.g. G10)

I am struggling to combine the SUMIF/SUMIFS and INDIRECT formulas, so perhaps someone could help.

In cell A1, I want the formula to display the SUM of

__all__values, that are

__between__the two dates specified (in B1/B2), for a sum range

__between__two cells specified (in cells D1/D2 in sheet C1)

So in my examples, A1 would show the sum of all values in Sheet2!G1:G10, if they are between 01/01/2016 and 31/12/2016 (but this would vary depending on the users choices)

Any help would be appreciated.