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 MSBACSB

I though it was possible to do like this:

=SUMIF(MSB;MSBACSB;SV)

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


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=546433

=SUMPRODUCT(--(MSBACSB),SV)

HTH
--
AP

"a94andwi" a écrit
dans le message de news:
...

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 MSBACSB

I though it was possible to do like this:

=SUMIF(MSB;MSBACSB;SV)

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


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile:
http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=546433

thank you. =SUMPRODUCT(--(MSBACSB),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 MSBACSB AND SYS="E"

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

=SUMPRODUCT(((MSBACSB)*(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
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=546433

thank you. =SUMPRODUCT(--(MSBACSB),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 MSBACSB AND SYS="E"

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

=SUMPRODUCT(((MSBACSB)*(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
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=546433