This is only my 2nd post, but the 1st one was so helpful, I'm going back to the well. I have a formula that isn't working the way I think it should:
=SUM(SUMIFS(c2:c9,b2:b9,{">=6037","<=6332",4010},a2:a9,{100,101,134,136,141,355,357})) ---- How can I fix this???
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
=SUM(SUMIFS(c2:c9,b2:b9,{">=6037","<=6332",4010},a2:a9,{100,101,134,136,141,355,357})) ---- How can I fix this???
A | B | C | |
1 | Dept | Acct | Amt |
2 | 100 | 6000 | 10 |
3 | 200 | 6100 | 15 |
4 | 141 | 6107 | 20 |
5 | 100 | 6108 | 25 |
6 | 355 | 6109 | 30 |
7 | 141 | 6110 | 35 |
8 | 357 | 4010 | 40 |
9 | 100 | 5000 | 50 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>