[Solved] If Then Else in one cell

[keithbakerlv]

I know how to use IF/Then/Else statements but is there any way to make once cell control an entire rows instead of putting the statement in multiple cells? The idea would be to add all of the values from Col C together that didn't have an integer in Col B and have them displayed in Cell A. For instance:

Cell A: IF (any cell in Col B is blank; add corresponding Row in Col C; 0)

[Zizi64]

The idea would be to add all of the values from Col C together that didn't have an integer in Col B and have them displayed in Cell A. For instance:

Cell A: IF (any cell in Col B is blank; add corresponding Row in Col C; 0)

Please upload our ODF type sample file here with the "before"-"after" states.

[keithbakerlv]

When I was making the spreadsheet example to show you I accidentally stumbled on the answer.

It was: =SUMIF(C2:C7,">1",D2:D7) for invoices that have a paid date in Col C and =SUMIF(C2:C7,"",D2:D7) for invoices that don't have a paid date. Thank you for your help. I attached the example ODF so if anyone else gets here trying to figure out the same thing they can look at it.