Thread: Sum all sheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Sum all sheets

=SUM(Sheet1:Sheet3!N25)

and adjust the worksheet names to match your needs.
--
Gary''s Student - gsnu200785


"wally" wrote:

I have a workbook, with multiple sheets, each with it's own name. Each sheet
has a cell, ie N25, which represents a count function on that sheet. Now, I
would like to place the sum of N25 of all the sheets on a summary sheet. Is
it possible to do this with or without using a macro? If it is, I could use
your help. Many thanks.

Wally