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!!

Date	Description	Transaction/Check#	Debit	Credit	X
	RDC			100.00	X
	RDC		250.00
	Check			300.00	X

<tbody>
</tbody>

 

[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!