How do I add numbers from different tables?

N

Nancy

How do I total numbers from different tables into to one grand total table?
I have three tables within a file. I want to add figures from the three
tables into a fourth master table. How do I do this?
 
L

Luc

Nancy,
Select the cell containing your total and bookmark it e.g. total1, total2
and so on.
In your master table make a formula like SUM(total1;total2;total3).
That should do it.
Luc
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Treating multiple paragraphs as one 2
Weekly Report 2
Sub projects added as read only in Master file which are saved on sharepoint 1
Embed the same Excel multiple times 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Format column widths from one table to a separate table on same page 1
How to have two tables on same line? 1

Top