Thread: data ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 59
Default THANKS ALL

Thanks all
I will take a look


"greg" wrote in message
...
Hello,
I would like to define a named range
such as D5, D6, D7 as the range.
I define it as test1.
And I want to reference it somewhere else.
Say F8 (=test1)

But I want F8 to be the sum of all of these numbers in the range.
Is there a way to do this.
Besides making a different named cell D8 as the sum of D5-D7?

thanks