View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default how do i sum the same cell in numerous sheets behind a main

=SUM(FirstSheet:LastSheet!A1)


On 14 Maj, 15:13, njparamedic
wrote:
i am preparing a master worksheet to roll up numerous jobs. *i want to add
all cells in the same position behind the master sheet. *is there a sum
fourmula to accomplish this?