Ben has attended:
Excel Intermediate course
Counting
I set of data with values relating to the staff Enumber.
Each staff may have more than one row value and I want to count how many rows each staff number has.
RE: Counting
Hi Ben,
Thank you for the forum question.
You will need the Countif or Countifs function. The Countif needs two information. =Countif(Range,Criteria)
The range will be the range where you have the staff Enumber and Criteria will be the Enumber. If you create a list of all unique Enumbers Lets imaging that your list with the unique Enumbers is in the range K2:K30 and that you have the range of Enumber you want to count in the range A2:A200.
If you in L2 write =Countif($A$2:$A$200,K2) and then copy down the formula the Countif will count number of records for each Enumber.
I hope this makes sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
