View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default add cells together from different sheets within a workbook

=sheet1!a1+sheet3!b99+'sheet 999'!x99
or
=sum(sheet1!a1,sheet3!b99,'sheet 999'!x99)



s6292 wrote:

How do I add cells together from different sheets within a workbook


--

Dave Peterson