Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel Sum Range

Thread Tools
 
Search this Thread
 
Old 23 June 2002, 08:31 AM
  #1  
airhead
Scooby Regular
Thread Starter
 
airhead's Avatar
 
Join Date: Oct 2000
Posts: 184
Likes: 0
Received 0 Likes on 0 Posts
Question

In excel if you have 26 sheets called A,B,C....Z, and sheet AA (27) you want to sum the same cell for all 26 sheet, what's the command please ?
Old 23 June 2002, 11:42 AM
  #2  
markr1963
Scooby Regular
 
markr1963's Avatar
 
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes on 0 Posts
Post

If the cell you want to sum is A1 on all sheets put the following into your cell on AA sheet

=SUM('A:Z'!A1)

HTH

edited for typos

[Edited by markr1963 - 6/23/2002 11:42:34 AM]

[Edited by markr1963 - 6/23/2002 4:35:51 PM]
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
fumbduck
ScoobyNet General
18
29 September 2015 09:16 PM
Pro-Line Motorsport
Car Parts For Sale
2
29 September 2015 07:36 PM



Quick Reply: Excel Sum Range



All times are GMT +1. The time now is 01:17 PM.