|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com