Calculate value for postive numbers only

[chally3]

Hi everyone,

Can anyone point me in the direction of where I am going wrong. I am trying to sum 2 cells , but only if positive number. This seems easy enough but I cannot get the formula to work.

Column D = Qty on hand
Column P = Cost
Column T = free stock qty (Which can be a negative value)

What I am trying to do is calculate values in rows :ie D2*P2 if T2 is more than "0"

If have tried -SUMIF(D2*P2,">0") but this is not working.


Thank you in advance

 

[footoo]

=if(t2 > 0,d2*p2)

 

[Rick Rothstein]

Can anyone point me in the direction of where I am going wrong. I am trying to sum 2 cells , but only if positive number. This seems easy enough but I cannot get the formula to work.

Column D = Qty on hand
Column P = Cost
Column T = free stock qty (Which can be a negative value)

What I am trying to do is calculate values in rows :ie D2*P2 if T2 is more than "0"

If have tried -SUMIF(D2*P2,">0") but this is not working.

The first argument to the SUMIF function must be a range... you have a multiplication of values there. However, you formula wouldn't work correctly even if you could use a multiplication because it is not dependent on cell T2. I think this more straightforward formula will do what you want...

=IF(T2>0,D2*P2,0)

 

[chally3]

Thank you, absolutely perfect