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