COUNTIFS with less than greater than

[EswarA]

Hello,
Please help me to get count after some conditions.
Pls find below excel sheet with columns DP, Txn Code, Product, Amount.
Conditions to consider:
DP- 1259
Txn code- 1401
Product- 1 to 200, 300 to 600, above 800.
Txn amount- <45000

I am writing formula which is wrong
=COUNTIFS(A:A,"1259",B:B,"1401",COUNTIFS(C:C,"<200",C:C,">800")+COUNTIFS(C:C,">300",C:C,"<600"),D:D,"<45000")

Please guide and provide simple formula.

 

[Anthony47]

I suggest you use SUMPRODUCT.
For example, if G3 and downward you have your DP numebers, in H3-I3 you have your Txn codes, then try in H3

=SUMPRODUCT(--($A$2:$A$1000=$G3),--($B$2:$B$1000=H$2),($C$2:$C$1000>1)*($C$2:$C$1000<200)+($C$2:$C$1000>300)*($C$2:$C$1000<600)+($C$2:$C$1000>800))

Adapt those "1000" in case you plan to have more than 1000 rows of data

Then copy H3 to the right (for more Txn codes) and down (for all of your DPs)

Bye

 

[EswarA]

I suggest you use SUMPRODUCT.
For example, if G3 and downward you have your DP numebers, in H3-I3 you have your Txn codes, then try in H3

=SUMPRODUCT(--($A$2:$A$1000=$G3),--($B$2:$B$1000=H$2),($C$2:$C$1000>1)*($C$2:$C$1000<200)+($C$2:$C$1000>300)*($C$2:$C$1000<600)+($C$2:$C$1000>800))

Adapt those "1000" in case you plan to have more than 1000 rows of data

Then copy H3 to the right (for more Txn codes) and down (for all of your DPs)

Bye

Thank you