BroadSpectrum
New Member
- Joined
- Oct 18, 2019
- Messages
- 5
Hello, I hope I can explain this properly as english is not my native tongue.
the first table takes its information from the bottom table that is usually in another worksheet by using Index Match
I've been trying to make my 3rd column (2+) add the amount from the Indexed Matched row if the age in days (worksheet 2) is greater than 1 day.
I realize my english may not explain what i'm really achieve but i'm willing to answer questions if you have any
<tbody>
</tbody>
<tbody>
</tbody>
the first table takes its information from the bottom table that is usually in another worksheet by using Index Match
I've been trying to make my 3rd column (2+) add the amount from the Indexed Matched row if the age in days (worksheet 2) is greater than 1 day.
I realize my english may not explain what i'm really achieve but i'm willing to answer questions if you have any
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Age in Days (worksheet 1) | 1 | 2+ | ||||||
2 | Total from another thing | ||||||||
3 | Total | 11 | #VALUE! | ||||||
4 | Queue 1 | 0 | #VALUE! | ||||||
5 | Queue 2 | 1 | |||||||
6 | Queue 3 | 0 | |||||||
7 | Queue 4 | 4 | |||||||
8 | Queue 5 | 6 | |||||||
9 | |||||||||
10 | Age in days (worksheet 2) | 1 | 2 | 5 | 9 | 15 | 17 | 23 | 25 |
11 | Total from another thing | 32 | 12 | 21 | 13 | 43 | 45 | 31 | 21 |
12 | Total | 11 | 7 | 10 | 12 | 5 | 16 | 10 | 15 |
13 | Queue 2 | 1 | 2 | 5 | 3 | 1 | 6 | 3 | 4 |
14 | Queue 4 | 4 | 2 | 3 | 4 | 1 | 5 | 2 | 5 |
15 | Queue 5 | 6 | 3 | 2 | 5 | 3 | 5 | 5 | 6 |
<tbody>
</tbody>
Sheet1
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>