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

DebitAmount	CreditAmount
1,250.00	-
3,000.00	-
75,000.00	-
-	100,000.00
16.92	-
50,000.00	-
-	125,000.00
16.92	-
-	(23.75)

<tbody>
</tbody><colgroup><col><col></colgroup>

 

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