Thread: consolidating data - 3d formula changes from what I type in
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dorsecraig dorsecraig is offline
external usenet poster
  
Posts: 1
Default consolidating data - 3d formula changes from what I type in
when I put in formula in consolidation sheet --- =sum(sheet1:sheet31!b32) and
hit enter -- "#name### shows up in cell and formula bar shows -
=SUM(SHEET1:'sheet1:[sheet31]SHEET31'!B32)
--
thanks for being there - have a great day
Reply With QuoteReply With Quote