View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UCHA UCHA is offline
external usenet poster
 
Posts: 4
Default spread sheets - adding

How can I add the same cell of diverse contiguous spread sheets; example:
(Pla1 H1 + Pla2 H1 + ...). the formula is: [=(Pla1!H1;Plan2!H1; ...)];
however, if I will add many spread sheets (50), the formula will be extremely
great. How can I simplify the formula?