Hello Everyone, wondering if someone might be able to help me out with a formula I am having trouble with. I have researched the formula extensively on-line and can't seem to get it to work. Basically, I am trying to use a sumifs formula with multiple criteria that sums across multiple worksheets using the indirect formula (see example below). I believe it can be done, but just cant seem to get it to work. Any help is much appreciated!
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Sum Range | Criteria 1 | Criteria 2 | ||||||||||||||||
2 | Sheet Reference | Column | Row | Column | Row | Column | Row | ||||||||||||
3 | Sheet1 | I | 9 | f | 9 | I | 8 | ||||||||||||
4 | Sheet2 | X | 15 | f | 15 | X | 8 | ||||||||||||
5 | |||||||||||||||||||
6 | |||||||||||||||||||
7 | Month | ||||||||||||||||||
8 | Cost Category | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||
9 | a | 18 | 4 | 1 | 19 | 20 | 15 | 3 | 19 | 1 | 10 | 3 | 5 | 3 | 15 | 16 | 3 | ||
10 | b | 3 | 19 | 17 | 7 | 13 | 10 | 13 | 12 | 20 | 10 | 4 | 3 | 13 | 7 | 20 | 12 | ||
11 | c | 17 | 16 | 4 | 3 | 9 | 16 | 11 | 18 | 13 | 12 | 14 | 13 | 0 | 6 | 10 | 6 | ||
12 | d | 4 | 2 | 16 | 19 | 16 | 2 | 1 | 15 | 0 | 4 | 20 | 13 | 2 | 13 | 18 | 19 | ||
13 | e | 6 | 12 | 4 | 15 | 18 | 20 | 1 | 13 | 17 | 6 | 8 | 1 | 4 | 15 | 15 | 0 | ||
14 | f | 17 | 2 | 2 | 5 | 4 | 18 | 7 | 10 | 10 | 2 | 20 | 1 | 14 | 0 | 4 | 2 | ||
15 | g | 17 | 4 | 12 | 18 | 10 | 0 | 7 | 19 | 14 | 15 | 11 | 15 | 15 | 19 | 9 | 14 | ||
16 | |||||||||||||||||||
17 | RESULT | #VALUE! |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>