Sumif()?????

[a94andwi]

Hello.

I want to do a complex sumif calculation that I can not get to work.

I have these columns.
Automatically created safety buffer =ACSB
Manuall safety buffer = MSB
Stock value =SV

I want to sum all rows where MSB>ACSB

I though it was possible to do like this:

=SUMIF(MSB;MSB>ACSB;SV)

This doesn't work. Is it possible to do it this way or do I have to d
it another way

 

[Ardus Petus]

=SUMPRODUCT(--(MSB>ACSB),SV)

HTH

 

[a94andwi]

thank you. =SUMPRODUCT(--(MSB>ACSB),SV) worked very well.

Now I need to add another criteria in the above to show the correct
values.
I want to add a new column, lets call it SYS and do this:

I want to sum all rows where MSB>ACSB AND SYS="E"

I guess it should be able to do it this way:

=SUMPRODUCT(((MSB>ACSB)*(SYS="E")),SV) and it returns a value. The
thing is that it seems to be wrong when I count it manually.

Is the formula above correct?

 

[a94andwi]

thank you. =SUMPRODUCT(--(MSB>ACSB),SV) worked very well.

Now I need to add another criteria in the above to show the correct
values.
I want to add a new column, lets call it SYS and do this:

I want to sum all rows where MSB>ACSB AND SYS="E"

I guess it should be able to do it this way:

=SUMPRODUCT(((MSB>ACSB)*(SYS="E")),SV) and it returns a value. The
thing is that it seems to be wrong when I count it manually.

Is the formula above correct?