I have a formula as below :
This basically looks for a code in column E and adds up each instance where the code is found with the figure in column J (for the value defined in Summary!F15).
I would like to do something slightly different with the formula.
Instead of using column J to count up a total, I would like to look at column F which has a name in it and count the number of unique names in it and give a total of this?
Can this be done?