| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| intersection of a row with a column | Excel Discussion (Misc queries) | |||
| How To Format Row Column Intersection | Excel Discussion (Misc queries) | |||
| LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW | Excel Worksheet Functions | |||
| I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES | Excel Worksheet Functions | |||
| intersection of row and column | Excel Worksheet Functions | |||
Hybrid Mode
