Need help with IF AND command

[mrafiq44]

I need to identify transaction amounts in 2 different columns as shown below, either debit or credit will have an amount. I need to identify how many transactions are below $5000, $25000, $50000, 100,000 & 200,000, so any help would be appreciated
[TABLE="width: 208"]
<tbody>[TR]
[TD] DebitAmount [/TD]
[TD] CreditAmount [/TD]
[/TR]
[TR]
[TD] 1,250.00 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] 3,000.00 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] 75,000.00 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD]100,000.00 [/TD]
[/TR]
[TR]
[TD] 16.92 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] 50,000.00 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD] 125,000.00 [/TD]
[/TR]
[TR]
[TD] 16.92 [/TD]
[TD] - [/TD]
[/TR]
[TR]
[TD] - [/TD]
[TD] (23.75)[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[AlanY]

may be

Excel 2013/2016
	A	B	C	D	E	F
1	DebitAmount	CreditAmount			Debit	Credit
2	1,250.00	-		5000	4	1
3	3,000.00	-		25000	0	0
4	75,000.00	-		50000	1	0
5	-	100,000.00		100000	1	1
6	16.92	-		200000	0	1
7	50,000.00	-
8	-	125,000.00
9	16.92	-
10	-	-23.75
Sheet7

Cell Formulas
Range	Formula
E2	=COUNTIFS(A$2:A$10,">"&MAX(-100000000,$D1),A$2:A$10,"<="&$D2)