delete rows but count data

Is there a way to take this file and delete duplicates found in column B but count all of the duplicates with OK in column D? Would be ok to add a column to the sheet that shows count.