Hi all
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.
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.