Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 63
Default in excel how do you total 1 cell on 25 different tabs?

in excel how do you total 1 cell on 25 different tabs?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default in excel how do you total 1 cell on 25 different tabs?

Hi Neal

See
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"neal" wrote in message ...
in excel how do you total 1 cell on 25 different tabs?

  #3   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I total only a % of a number (cell) base on total of all cel Douglas Excel Discussion (Misc queries) 2 October 6th 06 09:52 PM
In Excel, how can i see all tabs in format cell - I only see font. Jared Excel Discussion (Misc queries) 1 October 28th 05 09:55 PM
format cell tabs hidden in excel dialog box briangw Excel Discussion (Misc queries) 0 June 3rd 05 03:05 PM
In excel - how to total column if am not sure of the last cell PFHMoney New Users to Excel 4 May 27th 05 01:27 PM
3 format cell tabs hidden in excel dialog box pjbjamison Excel Discussion (Misc queries) 1 May 4th 05 04:50 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"