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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding sums from two spread sheets and putting answer someplace else

Status
Not open for further replies.
womp

womp

Technical User
Apr 6, 2001
105
US
If you have 3 columns of numbers on one spread sheet
and two columns of numbers on the second spread sheet
What, if any, formula, could you have, to add all the numbers up on both sheets and put the answer on the third spread sheet?
 
Sort by date Sort by votes
=sum(Sheet1!A:B)+sum(Sheet2!A:C)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kwbMitel
  • Locked
  • Question
I can't add sheets to my Excel file because it's protected.
Replies
4
Views
2K
StilLearningAlot
StilLearningAlot
OCM
  • Locked
  • Question
Compare two columns
Replies
2
Views
2K
OCM
OCM
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
946
OzFoxy
OzFoxy
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
798
SkipVought
S
R
  • Locked
  • Question
Issues with Outlook default account and performance
Replies
0
Views
556
radleymartinez
R

Part and Inventory Search

Sponsor

Back
Top