I'm using a SUMIFS formula to sum the values in a range based on set criteria.
So far I've got "=SUMIFS($P$1:$P$2000,$B$1:$B$2000,"
The issue is, I only want to sum values where criteria 1 is the same and where criteria 2 is equal to F1 and F6. Any ideas?
<tbody>
</tbody>
So far I've got "=SUMIFS($P$1:$P$2000,$B$1:$B$2000,"
The issue is, I only want to sum values where criteria 1 is the same and where criteria 2 is equal to F1 and F6. Any ideas?
Criteria 1 | Criteria 2 (region) | Sum Range | Return Column |
00002 | F1 | -40 | =SUMIFS($P$2.. |
00002 | F2 | 5 | |
00002 | F5 | 25 | |
00002 | F6 | 50 | |
00045 | F1 | -20 | |
00056 | F1 | -10 | |
00056 | F3 | 34 | |
00075 | F1 | -15 | |
00075 | F5 | 35 | |
00075 | F6 | 40 |
<tbody>
</tbody>