Countifs

Resolved · Low Priority · Version 2016

Wed 5 Jun 2019, 10:51 Delegate Fraser said...

Fraser has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Countifs

How do I count multiple text values in a range of cells in one of the countifs parts.

Wed 5 Jun 2019, 11:33 Trainer Jens said...

RE: Countifs

Hi Fraser,

Thank you for the forum question.

I am not sure what you mean by "in one of the countifs parts".

The Countifs can count how many times you have a specific text string or number in a range. It can work with from 1 to 128 criteria.

If you have a range A2:A200 with month names and want to count how many times you have the month name January the function should look like this:

=CountIfs(A2:A200,"January")

If you want to count how many times you have January or February:

=CountIfs(A2:A200,"January") + CountIfs(A2:A200,"February")

If you have staff names in column B and want to count how many times you have January in column A and John in Column B:

=Countifs(A2:A200,"January",B2:B200,"John")

Please let me know if this is not what you are looking for.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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