mediumraresteak
New Member
- Joined
- Jan 14, 2016
- Messages
- 13
Hi,
I'm trying to sumif one column with two conditions if possible. If I want to pull wte's total for all warehouses, it should be five. But when I put in the second condition to account for "whse 2", I get zero. Is it looking for both conditions in the same cell? How can I separate it to pull one total? Thanks in advance cause I've been trying for a couple of hours to no avail.
Here's an example: =SUMIFS(A:A,C:C,E1,B:B,"whse 1",B:B,"whse 2")
A B C
<tbody>
</tbody>
I'm trying to sumif one column with two conditions if possible. If I want to pull wte's total for all warehouses, it should be five. But when I put in the second condition to account for "whse 2", I get zero. Is it looking for both conditions in the same cell? How can I separate it to pull one total? Thanks in advance cause I've been trying for a couple of hours to no avail.
Here's an example: =SUMIFS(A:A,C:C,E1,B:B,"whse 1",B:B,"whse 2")
A B C
1 | whse 1 | wte |
1 | whse 1 | wte |
1 | whse 1 | wte |
1 | whse 2 | wte |
1 | whse 2 | wte |
1 | whse 4 | wte |
<tbody>
</tbody>
Last edited: