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

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


Thread Tools
Search this Thread

All times are GMT +1. The time now is 09:39 AM.