View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default working with format 01-01-08

Maybe

=SUM('01-01-08:01-31-08'!C51)

Mike

"rwe" wrote:

trying to consolidate ragne c51 on 31 sheets with name format 01-01-08 to
01-31-08. =sum('01-01-08':'01-31-08'!C51) doesn't work any suggestions