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