calculation

[Esrei]

I have a spreadsheet B-N

I want a formula that:
in M: if value in C = 1001 sum values in N with the same
reference in B. Some sort of sum if but the value in the
same line as 1001 must not be included.

 

[lsu-i-like]

this isnt clear enough for me to follow.

something like:

=if(c1=1001,SUM(N1:N10),

 

[dcronje]

From my understanding you may be looking for something like this:

=SUMPRODUCT(($C$1:$C$100=1001)*($B$1:$B$100=$B1)*($N$1:$N$100))-$N1


Feedback would be appreciated