Below is a possible solution to the Challenge 24 – Sum a Range Conditionally where Range Inputs are variables
Put following formula for the result -
The workbook illustrating the solution can be downloaded from Solution - Challenge 24 – Sum a Range Conditionally where Range Inputs are variables
--- 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.