Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Sum formula across worksheets

Status
Not open for further replies.
Vmanda

Vmanda

Technical User
Nov 16, 2001
5
US
We have a workbook with over 20 tabs, is there an easy way to add the same cell in each tab, without having to click on each cell in each workbook?
ie:
=('2003'!C374+'2002'!C374+Sheet3!C374)

thanks
Mandy
 
Sort by date Sort by votes
Use a formula such as this:


=SUM(Sheet1:Sheet3!A1)

With sheet1 being the first sheet in your workbook and Sheet3 being the last sheet.

HTH,
Eric
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
309
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
177
TomSalvato
TomSalvato
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
305
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
299
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
895
shytott
shytott

Part and Inventory Search

Sponsor

Back
Top