Excel

Resolved · Low Priority · Version 2016

Wed 1 Nov 2017, 15:34 Delegate Marco said...

Marco has attended:
Multiple applications course

Excel

Is it possible to create a formula to count the number of certain coloured cells in an excel document

Wed 1 Nov 2017, 16:01 Trainer Jens said...

RE: Excel

Hi Marco,

Thank you for the forum question.

Yes and No.

Yes if you know how to use VBA codes in Excel.

No using a formula.

The countif or Countifs function can count one criteria or many but unfortunately not colours.

The countif structure:

=Countif(range,Criteria)

If you want to count how many values you have greater than 200 in the Excel range A1:A200 the function should look like this:

=Countif(A1:A200,">"&200)

If you want to count how many times you have "HR" in the Excel range A1:A200 the function should look like this:

=Countif(A1:A200,"HR")

The countif can work with one criteria the Countifs with from 1 to 128 criteria.

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Microsoft Office tip:

Automated backup with Recovery Pane.

If you ever have a serious error with Office 2003, there is a backup of the work that appears in the Recovery Pane when the application stats up again. You can choose to delete or save the files so that you can spend more time on creating documents, not recreating them.

View all Microsoft Office hints and tips