Thread: Search spread sheet of times and areas to find discrepancies.

Hi I oversee meters, when a tech goes to one he swipes a card to identify the meter has been serviced. I have a report of times, meter #, meter areas and card #'s used. I need to identify who has been skipping meters.
I sorted the info by area and card # matching them up in the spread sheet, but i need a formula to count the number of meters where scaned by a certian card #. I need to search the info and have it give me the total # of meters where scaned by a card #. Can you help