Yippy_Kiyey
Board Regular
- Joined
- Sep 28, 2008
- Messages
- 96
I have a spreadsheet that has 51 tabs. The first tab is a summary page of the other 50 tabs. The columns are identical but the rows are not although they contain similar information. I need to summarize this tabs by bringing or linking certain total onto the summary page. Right I do that by using the "=" sign, but it takes so much time and very prone to errors. I want a formula that will link all the totals that I can copy across or down. This will be more efficient and accurate. Below is an example.
Excel Workbook | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
2 | Tab1 - Summary | ||||||
3 | Funded | Jan | Feb | etc | |||
4 | 101 | ||||||
5 | 102 | ||||||
6 | 103 | ||||||
7 | Total Funded | ||||||
8 | |||||||
9 | Not Funded | ||||||
10 | 101 | ||||||
11 | 102 | ||||||
12 | 103 | ||||||
13 | Total Not Funded | ||||||
14 | |||||||
15 | |||||||
16 | Tab-Proj 101 | ||||||
17 | Funded | ||||||
18 | Items | Jan | Feb | etc | |||
19 | AAA | 10 | 11 | ||||
20 | BBB | 10 | 11 | ||||
21 | CCC | 10 | 11 | ||||
22 | Total Funded | 30 | 33 | ||||
23 | (Link this total to line 6 Tab1 - Summary) | ||||||
24 | |||||||
25 | Not Funded | ||||||
26 | Items | ||||||
27 | AAA | 5 | 8 | ||||
28 | BBB | 5 | 5 | ||||
29 | CCC | 3 | 3 | ||||
30 | Total not funded | 13 | 16 | ||||
31 | (Link this total to line 12 Tab1 - Summary) | ||||||
32 | |||||||
33 | Tab-Proj 102 | ||||||
34 | Funded | ||||||
35 | Items | Jan | Feb | etc | |||
36 | DDD | ||||||
37 | EEE | ||||||
38 | Total Funded | ||||||
39 | (Copy this total to line 7 Tab1 - Summary) | ||||||
40 | Not Funded | ||||||
41 | Items | ||||||
42 | DDD | ||||||
43 | EEE | ||||||
44 | Total not funded | ||||||
45 | (Copy this total to line 13 Tab1 - Summary) | ||||||
Sheet1 |