Thread: summing name range in the same column with Dynamic name ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
  
Posts: 921
Default summing name range in the same column with Dynamic name ranges
Hi all,
I have a dynamic name range in a column, say colA with name Test from A7
to the end of the column. When I set A5 = sum(test), it always gives me 0.
Any idea why?

Thanks,
Reply With QuoteReply With Quote