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 Jun 23, 2002 | 08:31 AM
  #1  
airhead's Avatar
airhead
Thread Starter
Scooby Regular
 
Joined: Oct 2000
Posts: 184
Likes: 0
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 ?
Reply
Old Jun 23, 2002 | 11:42 AM
  #2  
markr1963's Avatar
markr1963
Scooby Regular
 
Joined: Jun 2002
Posts: 1,866
Likes: 0
From: Perth, Western Australia
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]
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
leg200
Subaru Parts
5
Oct 7, 2015 07:31 AM
fumbduck
ScoobyNet General
18
Sep 29, 2015 09:16 PM
Pro-Line Motorsport
Car Parts For Sale
2
Sep 29, 2015 07:36 PM




All times are GMT +1. The time now is 07:59 AM.