Formula for multiple conditions

[Krayziekitten]

Hello,

I need help with a formula please! I'm creating a summary page that shows amounts per month.
I am trying to create a formula that will go out to the correct tab, and return a net amount when two conditions are met.

Below is an example table. I want the formula to return the sum of the Credit less Debit based upon these two conditions:
Condition 1: Description = RDC
Condition 2: X shows an X

I've tried several different ways, however I cannot seem to get it to work right. And if possible, I don't want to add another column concatenating the Description with the X column to do a SUMIF.

So, when the formula is working correct I should receive a total of 100.00 for RDC totals.

Thanks in advance!!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Description[/TD]
[TD]Transaction/Check#[/TD]
[TD]Debit[/TD]
[TD]Credit[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RDC[/TD]
[TD][/TD]
[TD][/TD]
[TD]100.00[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]RDC[/TD]
[TD][/TD]
[TD]250.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Check[/TD]
[TD][/TD]
[TD][/TD]
[TD]300.00[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]

 

[BQardi]

Use SUMIFS instead, you can enter multiple criteria with it:

=SUMIFS(E:E, B:B, "RDC", F:F, "x")

And if you want to subtract Credit from Debit:

=SUMIFS(D:D, B:B, "RDC", F:F, "x")-SUMIFS(E:E, B:B, "RDC", F:F, "x")

In your example table, this would still give a result of 100.00...

 

[Krayziekitten]

Worked perfect - thank you!