Sum of values in variable range

[Lawman]

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

 

[Bernard Liengme]

=SUM(INDEX(mydata,A1,2):INDEX(mydata,B1,2))
where 'mydata' was the name of my (3 column * 20 row) range
best wishes

 

[Lawman]

Don't worry - I seem to have solved it with =SUM(OFFSET(....) function. Or
do you know a more elegant way?

L

 

[Bernard Liengme]

You don't like my way? Sob!!!
best wishes

 

[Ragdyer]

Hey Bernard ... is that sob a weep? ... or a son of a b----?<vbg>

 

[Bernard Liengme]

No, just weep. I would never insult an OP !