calculation

E

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.
 
L

lsu-i-like

this isnt clear enough for me to follow. :confused:

something like:

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

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
 
Top