Use intersection of column and TWO ranges in formula?
 

Thanks to those who helped before, I can use the intersection of a column
and a named range in a formula, as in
=STDEV((col7 rng1Work)).

Now, what happens when I want to calculate across TWO ranges? As in
=STDEV of the values in the intersection of the range "col7" and all the
values in both "rng1Work" and "rng2Work"?
If "col7" was column "D", rng1Work included rows 4-7, and rng2Work included
rows 14-17, this would be the equivalent of
=STDEV(D4:D7, D14:D17).

Ed

Use intersection of column and TWO ranges in formula?
 

=STDEV(col7 rng1Work,col7 rng2Work)

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
Thanks to those who helped before, I can use the intersection of a column
and a named range in a formula, as in
=STDEV((col7 rng1Work)).

Now, what happens when I want to calculate across TWO ranges? As in
=STDEV of the values in the intersection of the range "col7" and all the
values in both "rng1Work" and "rng2Work"?
If "col7" was column "D", rng1Work included rows 4-7, and rng2Work
included
rows 14-17, this would be the equivalent of
=STDEV(D4:D7, D14:D17).

Ed

Use intersection of column and TWO ranges in formula?
 

Perfect! Thanks, Tom.

Ed

"Tom Ogilvy" wrote in message
...
=STDEV(col7 rng1Work,col7 rng2Work)

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
Thanks to those who helped before, I can use the intersection of a
column
and a named range in a formula, as in
=STDEV((col7 rng1Work)).

Now, what happens when I want to calculate across TWO ranges? As in
=STDEV of the values in the intersection of the range "col7" and all the
values in both "rng1Work" and "rng2Work"?
If "col7" was column "D", rng1Work included rows 4-7, and rng2Work
included
rows 14-17, this would be the equivalent of
=STDEV(D4:D7, D14:D17).

Ed