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