detangler
Board Regular
- Joined
- Oct 21, 2003
- Messages
- 74
Here's what I have:
Sheet Name is the name to all of the worksheets that I need to sum. All of these sheets (income statements) are formatted the exact same way. Each of these statements need to roll up to its specified grouping. So the end product is that I will have 6 rollup summary sheets formatted the exact same way as these individual income statement.
I have read and re-read the Index, Match, Indirect, SumIf functions and posts on this site over and over again and just couldn't figure it out. Can someone please help!!! Thank you so much!
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Service Line | Sheet Name | Grouping | |||
2 | X-Ray | SL1 | Standalone Imaging | |||
3 | Computed Tomography | SL2 | Imaging Joint Venture | |||
4 | Magnetic Resonance Imaging | SL3 | Standalone Imaging | |||
5 | PET | SL4 | East Ambulatory Center | |||
6 | Mammography | SL5 | East Ambulatory Center | |||
7 | Endoscopy | SL6 | (Reserved for Future #2) | |||
8 | Cystoscopy | SL7 | East Ambulatory Center | |||
9 | Nuclear Stress | SL8 | West Ambulatory Center | |||
10 | Cardiac Rehab | SL9 | East Ambulatory Center | |||
11 | Echocardiology | SL10 | Standalone Imaging | |||
12 | Occupational Medicine | SL11 | Standalone Imaging | |||
13 | Radiation Oncology | SL12 | West Ambulatory Center | |||
14 | Medical Oncology | SL13 | East Ambulatory Center | |||
15 | Diagnostic Cath | SL14 | West Ambulatory Center | |||
16 | Interventional Cath | SL15 | East Ambulatory Center | |||
17 | Orthopedics | SL16 | West Ambulatory Center | |||
18 | Physical Therapy | SL17 | East Ambulatory Center | |||
19 | Wellness Center | SL18 | (Reserved for Future #1) | |||
20 | PET-JV | SL19 | (Reserved for Future #1) | |||
21 | MRI-JV | SL20 | Standalone Imaging | |||
Sheet1 |
Sheet Name is the name to all of the worksheets that I need to sum. All of these sheets (income statements) are formatted the exact same way. Each of these statements need to roll up to its specified grouping. So the end product is that I will have 6 rollup summary sheets formatted the exact same way as these individual income statement.
I have read and re-read the Index, Match, Indirect, SumIf functions and posts on this site over and over again and just couldn't figure it out. Can someone please help!!! Thank you so much!