identify, count and sum diferent recurring values

Hello,

I've got a long sheet of product codes (col d,e,f,g) and need to write something that will identify the different unique values within those columns and count the number of occurances of each.

Have tried to count if and vlookup but there are a hundred or so unique values occurring over the 8000 rows on the sheet and I'd like to avoid looking and counting them wirh individual functions.

Any help would be great, thanks!