View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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