View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default in excel how do you total 1 cell on 25 different tabs?

If the data is in the same cell on every sheet, then where you want the total
type =sum( then shift and click the last sheet, this will select on in that
range, then click the cell that contains the data, then add a ) and hit enter.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"neal" wrote:

in excel how do you total 1 cell on 25 different tabs?