Count the pairs (positive and negative) of multiple criterias

Hello Excel Experts,

In an Accounting world, accountants always post numbers. However, when they want to 'reverse' the post, they'll do so with the opposite sign of the numbers that they had posted.

My question thus is, what combinations of functions do I need to use in order to return the result either as 1 or 0?
The pairs the posted numbers and the reverse of it with the same criterias return as 1, else 0.

For example

Criteria Column 1	Criteria Column 2	Amount	Desired Result
a	101	10	1
b	101	10	0 (there's no inverse pair)
c	101	15	0
a	101	-10	0 (this has been counted as the pair above)
a	101	10	0 (this is the 2nd time the same value is posted. But there's no inverse to make it a pair)
b	101	15	0 (there's no inverse pair)
c	101	15	0
c	102	80	1
c	102	80	1
c	102	-80	0 (this has been counted as the pair above)
c	102	80	0 (this is the 3rd time the same value is posted. But there's no inverse to make it a pair)
c	102	-80	0 (this has been counted as the pair above)