samantavelho
New Member
- Joined
- Jan 16, 2014
- Messages
- 6
Hi all,
I've been trying to find an answer to my problem, before bothering you, and I've already spent a few hours today browsing the treads here in the forum, but did not succeed to find a suitable answer
The thing is:
I need to have in (what wuld be in this case the cell) G2, the sum of id2 strk (column C) with strk behavior (column F), but only if id1 (for instance cell A2 1187876) is repeated in column A range, and if id2 (cell B2) is different from the value of the row I'm calculating (in this case different from 221497).
I've tried =sumifs(A:A=A2,B:B"<>"&B2,C:F) but didn't work.
bellow you can find the information.
<tbody>
</tbody>
I would be very thankful if any of you could shed some light.
Warm Regards,
I've been trying to find an answer to my problem, before bothering you, and I've already spent a few hours today browsing the treads here in the forum, but did not succeed to find a suitable answer
The thing is:
I need to have in (what wuld be in this case the cell) G2, the sum of id2 strk (column C) with strk behavior (column F), but only if id1 (for instance cell A2 1187876) is repeated in column A range, and if id2 (cell B2) is different from the value of the row I'm calculating (in this case different from 221497).
I've tried =sumifs(A:A=A2,B:B"<>"&B2,C:F) but didn't work.
bellow you can find the information.
id 1 | id 2 | id2 strk | BR strk | g+h | strk behavior | f+i if c=c & d <>d |
1187876 | 221497 | 1 | 0 | 1 | 0 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1500112 | 262430 | 2 | 0 | 2 | 0 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 227511 | 1 | 0 | 1 | 1 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 252576 | 1 | 0 | 1 | 1 | |
1100975 | 227511 | 1 | 0 | 1 | 1 | |
1180617 | 223753 | 2 | 0 | 2 | 0 | |
911330 | 234966 | 2 | 0 | 2 | 0 | |
101126 | 17397 | 2 | 0 | 2 | 0 |
<tbody>
</tbody>
I would be very thankful if any of you could shed some light.
Warm Regards,