summing totals from two worksheets

J

jason

Is there a way to sum two running totals from separate
worksheets in one main doc? If so, how?
 
B

Bernard Liengme

Hi Jason,
Summing two ranges from two sheets in same book:
=SUM(Sheet2!C1:C6,Sheet1!A1:A6)
Or to sum lots of pages =SUM(Sheet1:Sheet23!A1:B2)
Summing two ranges on two sheets on different books:
=SUM([Book1]Sheet1!$A$1:$A$6,[Book3]Sheet2!
$C$1:$C$6)
Best wishes
Bernard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup sum multiple matches 1
How to implement two shifts per day with multiple teams 0
How to create a bubble chart with more than 2 variables. 0
Multiple logic functions with multiple sums 2
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Auto Sum not working correctly 1
formula for arriving net difference 0
Match/Index/Sum function with date range 2

Top