Use intersection of column and TWO ranges in formula?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detect NULL (??) range? 4
Write to intersect of a row and column 7
How to write STDev formula in a macro 3
Using named range intersection in a sum funtion 3
Selecting non intersect 0
Intersect and Union 2
Intersection of two curves 7
Change_Event troubles, no error & no work. 6

Back
Top