Thread: How can I make a range "dynamic"?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How can I make a range "dynamic"?
Another option
Don't worry about using B1 and
=Sum(B:B)-Sum(B1:B22)

It elimnates the '9.9999999999999E+307' that I know Biff likes so much
<bg

Cheers RES

Reply With QuoteReply With Quote