if anyone can help with this i'll be so grateful, it's a bit complicated...

firstly, i want to count the number of times "Referral" occurs in column D
when there is a unique value in column A (A is the client attributor number).

secondly, i want to count the number of time "Referral" occurs in column D
when the attributor in column A is present more than once (multiple records
for the same client)

thirdly, what should i do to add another layer to this e.g. if i want to
know 'number of records where column A is unique value, column D =
"Referral", and column F = "Female" ' ?

i think i know how to get the individual bits but no idea how to link them
together to bring back the result for all the criteria at once!