sumifs or sumproduct? (or none?)

[samantavelho]

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.

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,

 

[AhoyNC]

You're welcome. Glad that worked for you. Thanks for the feedback and welcome to the forum.

 

[samantavelho]

My pleasure !