Hello there,
I have hit a bit of a stumbling block in a spreadsheet I am attempting to make.
The sheet comprises of a unique reference number, a name, and a yes or no entry.
I have a sumproduct / countif formula to count the number of unique contractors (based on the ref number). However...