Hi, I am new to this forum and currently having some problems with SUMIFS. I am trying to get the formula to check if criteria 1 and 2 are met and then if they are add the sum range value to get a total. For criteria 1 I found that the formula in G3 only notices 124 if the cell contains a letter and so the value in G3 is currently 2 but the total should be 19. Does anyone know where I might be going wrong?
<tbody>
</tbody>
A | B | C | D | E | F | G | |
1 | Criteria 1 range | Criteria 2 range | Sum range | Criteria 1 | 124 | ||
2 | P124 | Company A | 2 | Criteria 2 | Company A | ||
3 | 1246903 | Company A | 5 | Total | =SUMIFS(C2:C5,A2:A5,"*"&G1&"*",B2:B5,G2) | ||
4 | 521246 | Company A | 9 | ||||
5 | 124 | Company A | 3 |
<tbody>
</tbody>