Forum Discussion

MrStern's avatar
MrStern
Copper Contributor
Dec 12, 2019
Solved

Countifs duplicate of one value - differentiating when second value is negative or positive

Hi,

 

I am trying to create a count formula for the below scenario.

I am trying to count duplicates in one column, but only count them if they are either negative or positive values in a second column.

 

so as per image below, I am looking to count the Placement ID's (of which there are 4 ending in '312.

However I only want a result of 2 on each row as there are two Placements '312 that have a negative Local Amount, and there are two Placements that are positive Local Amount.

 

Any help would be appreciated.  I have tried all sorts of counts, and's if's etc with no luck for one reason or another.

 

Thanks!

Resources