IF then statement

**rkrieg** · 07-13-2010, 08:09 PM

I want to sum up the total of all successful transactions on a spreadsheet where column B says "Success" and column C has the amount of the transaction.

How do I have the formula check column b and then if it says "Success" add the value from column C??

Thanks in advanced!!

**martindwilson** · 07-13-2010, 08:16 PM

use sumif
sumif(b1:b100,"success",c1:c100)

**rkrieg** · 07-13-2010, 08:27 PM

Easy enough!! Thank you!!

**rkrieg** · 07-14-2010, 12:33 PM

Is it possible to do a DOUBLE sumif statement.....ie....if this AND that....then sum this column....

Pretty much combine the following statements so they both have to exist to sum column C....

sumif(b1:b100,"success",c1:c100)
sumif(c1:b100, "completed", c1:c100)

**rkrieg** · 07-14-2010, 01:06 PM

The statements are actually:

sumif(b1:b100,"success",c1:c100)
sumif(a1:a100, "completed", c1:c100)

Originally Posted by rkrieg

Is it possible to do a DOUBLE sumif statement.....ie....if this AND that....then sum this column....

Pretty much combine the following statements so they both have to exist to sum column C....

sumif(b1:b100,"success",c1:c100)
sumif(c1:b100, "completed", c1:c100)