--- Excel related to this challenge can be downloaded from Challenge - Sum a Range Conditionally ---
Suppose, you have values in column A and D1 and D2 contains the range references. D3 contains the condition value for greater than. In this example, you will need to sum up between A4 and A8 where values are > 30.
Of course, A4, A8 and 30 are variables and driven by values in D1, D2 and D3.
You may post your answers in comments section.
Note - Solution to this challenge will be published after 1 month i.e. on 28-Sep-15.