Count Ifs

Hi Nick,

Thank you for the forum question.

The Countifs function can handle from 1 to 128 criterias.

The structure of Countifs:

=Countifs(Criteria_Range1,Criteria1,Criteria_range2,Criteria2..........)

You can work with one criteria:

=Countifs(A1:A100,2016)

The function will return how many times you have 2016 in the range A1:A100.

Many criterias:

=Countifs(A1:A100,2016,B1:B100,"Region North",C1:C100,"November",D1:D100,"Jack")

The function will return in how many rows in the range A1:D100 you have 2016 in the range A1:A100 and Region North in the range B1:B100 and November in the range C1:C100 and Jack in the range D1:D100.

I hope this make 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