JRomaine1320
New Member
- Joined
- Jul 28, 2018
- Messages
- 3
So, i want to get totals using sumif but if i want to exclude a set of cells from totals based on criteria, how do i do that?
Ive got the sumifs total, but i want to exclude "not ok" from the total.
Most likely a combination of sumifs & if, but i cant get it.
Please see table below
<tbody>
</tbody>
Ive got the sumifs total, but i want to exclude "not ok" from the total.
Most likely a combination of sumifs & if, but i cant get it.
Please see table below
OK? | Item | QTY | Total |
OK | A | 100 | =SUMIFS(K:K,F:F,F2) |
OK | A | 100 | =SUMIFS(K:K,F:F,F2) |
NOT OK | A | 100 | =SUMIFS(K:K,F:F,F2) |
OK | A | 100 | =SUMIFS(K:K,F:F,F2) |
<tbody>
</tbody>