ShafiqqAziz
New Member
- Joined
- Jan 9, 2018
- Messages
- 6
Hello guys,
I need a help create a sum with 1 condition in multiple columns.
Here's an example:
<tbody>
</tbody>
What i'm trying to do here, i want the sum to be separated between negative and positive.
E.g:
<tbody>
</tbody>
I've tried SUMPRODUCT((A2:A5=A2)*(B2:E5>0)*(B2:E5)) give me #VALUE ! error.
Tried all of this
1. https://www.extendoffice.com/docume...ultiple-columns-based-on-single-criteria.html
2. https://support.office.com/en-us/ar...nditions-e610ae0f-4d27-480c-9119-eb644f1e847e
3. https://www.extendoffice.com/documents/excel/4097-excel-sum-based-on-column-and-row-criteria.html
Can you guys help me out?
I need a help create a sum with 1 condition in multiple columns.
Here's an example:
Quantity 1 | Quantity 2 | Quantity 3 | Quantity 4 | |
Item 1 | -1 | 0 | 1 | 2 |
Item 2 | 0 | -1 | 1 | 2 |
Item 3 | -2 | 1 | -1 | 2 |
Item 4 | 0 | 1 | 1 | -2 |
<tbody>
</tbody>
What i'm trying to do here, i want the sum to be separated between negative and positive.
E.g:
Quantity Negative | Quantity Positive | |
Item 1 | -1 | 3 |
Item 2 | -1 | 3 |
Item 3 | -3 | 3 |
Item 4 | -2 | 2 |
<tbody>
</tbody>
I've tried SUMPRODUCT((A2:A5=A2)*(B2:E5>0)*(B2:E5)) give me #VALUE ! error.
Tried all of this
1. https://www.extendoffice.com/docume...ultiple-columns-based-on-single-criteria.html
2. https://support.office.com/en-us/ar...nditions-e610ae0f-4d27-480c-9119-eb644f1e847e
3. https://www.extendoffice.com/documents/excel/4097-excel-sum-based-on-column-and-row-criteria.html
Can you guys help me out?