Help with Count If formula on unique values only
I am trying to add a count to my sheet summary which gives me the number of contracts which are a certain status within my sheet eg. pending, signed & returned etc but each contract can be listed a number of times within the sheet and I only want the contract to count once in my summary.
These entries are all for the same contract, 597, but in my count it shows as 25 entries not just 1.
I have seen a number of threads on similar issues and tried a whole combination of COUNTIFS, ANDS, COLLECT, DISTINCT formula combinations but each one has returned an error. Can anyone help me with the correct functions / formula for this?
Help Article Resources
Check out the Formula Handbook template!