P
Peter Bernadyne
I have 2 dynamic ranges which vary according to user input in a dropdown
box. I would like to create a 3rd range out of these which I am
attempting to do formulaicly using a Name embedded within the worksheet
and then return a singular value from this 3rd range (like its mean, or
sum, etc.). However, whenever I try to return this value, Excel
crashes. Does anyone know if this is possible to do?
To illustrate, here's what I mean:
1). First, I have setup 2 dynamic ranges, range1 and range2 (both
correctly specified as Named ranges).
Assume for the moment range1 refers to the numbers on Sheet1, column A,
rows 1:10. Also assume range2 refers to the numbers on Sheet1, column
B, rows 1:10.
2). I next define range3 as a named range which refers to:
range1-range2
3). Finally, I try to return sum(range3) (or any other aggregate
function) in any cell in a worksheet and Excel crashes. I've also
tried to enter a name for this value (as in Sum3 which refers to:
=sum(range3)) and this also fails.
Does anyone know if there is a workaround for this? I'm hoping to
avoid any embedded code to keep the workbook as 'light' as possible.
Any advice would be much appreciated!
-Pete
box. I would like to create a 3rd range out of these which I am
attempting to do formulaicly using a Name embedded within the worksheet
and then return a singular value from this 3rd range (like its mean, or
sum, etc.). However, whenever I try to return this value, Excel
crashes. Does anyone know if this is possible to do?
To illustrate, here's what I mean:
1). First, I have setup 2 dynamic ranges, range1 and range2 (both
correctly specified as Named ranges).
Assume for the moment range1 refers to the numbers on Sheet1, column A,
rows 1:10. Also assume range2 refers to the numbers on Sheet1, column
B, rows 1:10.
2). I next define range3 as a named range which refers to:
range1-range2
3). Finally, I try to return sum(range3) (or any other aggregate
function) in any cell in a worksheet and Excel crashes. I've also
tried to enter a name for this value (as in Sum3 which refers to:
=sum(range3)) and this also fails.
Does anyone know if there is a workaround for this? I'm hoping to
avoid any embedded code to keep the workbook as 'light' as possible.
Any advice would be much appreciated!
-Pete