Hello all. I don't know if SUMIFS is what will work here but I am trying to do some work with different criteria in different columns. I have tried different things but its not working. Can anyone help me out?!?! Thanks
If column A (text) is this and column B (numbers) is this, then sum column C. So in my table below, I want to find a row with "W" in column A and a "4" in column B, then add up column C (which would be total of 1 in this case). Hope I'm being clear in what I'm trying to do. Thanks!!
<tbody>
</tbody>
If column A (text) is this and column B (numbers) is this, then sum column C. So in my table below, I want to find a row with "W" in column A and a "4" in column B, then add up column C (which would be total of 1 in this case). Hope I'm being clear in what I'm trying to do. Thanks!!
L | 4 | 1 |
L | 8 | 1 |
L | 8 | 1 |
W | 10 | 1 |
W | 4 | 1 |
L | 9 | 1 |
<tbody>
</tbody>