| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of values in variable range
How do I add the numerical values in say the second column of a named range
(comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of values in variable range
=SUM(INDEX(mydata,A1,2):INDEX(mydata,B1,2))
where 'mydata' was the name of my (3 column * 20 row) range best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lawman" wrote in message ... How do I add the numerical values in say the second column of a named range (comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of values in variable range
Don't worry - I seem to have solved it with =SUM(OFFSET(....) function. Or
do you know a more elegant way? L "Lawman" wrote in message ... How do I add the numerical values in say the second column of a named range (comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of values in variable range
You don't like my way? Sob!!!
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lawman" wrote in message ... Don't worry - I seem to have solved it with =SUM(OFFSET(....) function. Or do you know a more elegant way? L "Lawman" wrote in message ... How do I add the numerical values in say the second column of a named range (comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of values in variable range
Hey Bernard ... is that sob a weep? ... or a son of a b----?<vbg
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bernard Liengme" wrote in message ... You don't like my way? Sob!!! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lawman" wrote in message ... Don't worry - I seem to have solved it with =SUM(OFFSET(....) function. Or do you know a more elegant way? L "Lawman" wrote in message ... How do I add the numerical values in say the second column of a named range (comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum of values in variable range
No, just weep. I would never insult an OP !
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ragdyer" wrote in message ... Hey Bernard ... is that sob a weep? ... or a son of a b----?<vbg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bernard Liengme" wrote in message ... You don't like my way? Sob!!! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Lawman" wrote in message ... Don't worry - I seem to have solved it with =SUM(OFFSET(....) function. Or do you know a more elegant way? L "Lawman" wrote in message ... How do I add the numerical values in say the second column of a named range (comprising say 3 columns and 20 rows) from row X to row Y, where X and Y are the results of calculations in, say, cells A1 and B1? Many thanks for your help L |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable range | New Users to Excel | |||
| Variable Range | Excel Worksheet Functions | |||
| from Range variable | Excel Discussion (Misc queries) | |||
| Variable in Range | Excel Discussion (Misc queries) | |||
| How to use a variable for a range | Excel Worksheet Functions | |||
Linear Mode
