Thread: how do i add up the same cell from multiple named tab sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default how do i add up the same cell from multiple named tab sheets
=SUM('sheet1:sheet20'!a1)

Reply With QuoteReply With Quote