atapp

Q: sum values      A             B    !7             -200    -61           -5    -4             27    19            -9    230          13   -100          -70    28            -3   I want the sum of multiplication as result of:  Multiply what is Only Neg

sum values

    A             B

 

   !7             -200

   -61           -5

   -4             27

   19            -9

   230          13

  -100          -70

   28            -3

  I want the sum of multiplication as result of:  Multiply what is Only Negative in Column A  to  it's adjacent  in Column B  if it is only Negative.

 

Many thanks for any help

iMac (21.5-inch Mid 2011), OS X Mavericks (10.9.3)

Posted on Mar 10, 2015 11:02 AM