Forum Discussion
MrStern
Dec 12, 2019Copper Contributor
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!
3 Replies
Sort By
- MrSternCopper Contributor
SergeiBaklanPerfect! Thanks
MrStern , you are welcome