I and trying to get the total of values in a table that belong to Dept A and have Codes after 9990.000.
the Result I get is 0 but it should be 50.
What is wrong with my SUMIFS formula?
Thank You
the Result I get is 0 but it should be 50.
What is wrong with my SUMIFS formula?
Thank You
Book1 | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
4 | |||||||
5 | Code | Dept | Value | ||||
6 | 9910.100 | A | 10 | ||||
7 | 9920.200 | B | 20 | ||||
8 | 9940.001 | B | 30 | ||||
9 | 9990.000 | C | 40 | ||||
10 | 9991.000 | A | 50 | ||||
11 | |||||||
12 | |||||||
13 | 0 | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H13 | H13 | =SUMIFS(Table1[Value],Table1[Dept],"A",Table1[Code],">9990.000") |