Count Ifs

Resolved · Low Priority · Version 2013

Wed 7 Dec 2016, 17:07 Delegate Nick said...

Nick has attended:
Excel Intermediate course
Excel Advanced course

Count Ifs

Could you please provide me the logic for how to implement multiple count if forumals where there are multiple criteria being used.

Thanks

Fri 9 Dec 2016, 09:25 Trainer Jens said...

RE: 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

Fri 16 Dec 2016: Automatically marked as resolved.

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Count Ifs

Count Ifs

RE: Count Ifs

Excel articles

Excel tip:

Edit and format multiple worksheets in one operation