Counting

Resolved · Low Priority · Version 2016

Fri 12 May 2017, 15:33 Delegate Ben said...

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.

Mon 15 May 2017, 09:32 Trainer Jens said...

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

Mon 22 May 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips