I have a spreadsheet whereby I need to be able to count how many unique items
are in column D (D5 onwards), where each corresponding value in column O is a
non-blank.

Is there an easy way to do this and if so, how?

Many thanks in advance.