Using the countif formula should do this (It will count how many times the value is in a range) however if this is something that you are going to running a lot it may be better to get a VBA script for it that could do it automatically for you.