jeudi 23 avril 2015

Excel: Count number of cells based on criteria

I have an excel spreadsheet that contains a "Customer ID" field and a "Check ID" field. I need to count the number of check id's associated with that customer id for a specific date?

## Customer ID ##  ## Check ID##  ## Check Date##

   2554               823488         04/24/2015
   2554               823489         04/24/2015
   4856               823450         04/24/2015

So Customer 2554 would have a count of 2 and Customer 4856 would have a count of 1.

Aucun commentaire:

Enregistrer un commentaire