count if and count

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » COUNT IF and COUNT IFS

COUNT IF and COUNT IFS

resolvedResolved · Low Priority · Version 2007

COUNT IF and COUNT IFS

When creating a formula when might you use COUNT IF and why might you use COUNT IFS instead

RE: COUNT IF and COUNT IFS

Hi Kate, thanks for your query. COUNTIF only counts those values in a single column that match a certain criteria. But consider:

A B
1 a
2 b
3 c
4 b
2 b

How would you count only those cells where the values are 2 and b, in the separate columns? Two separate COUNTIF fomulas and then add the results? You could use the COUNTIFS function to do so instead:

=COUNTIFS(A1:A5, "2", B1:B5, "b")

Basically, we talking multiple criteria checking. You can also do this with the array formulas I mentioned.

Hope this helps,

Anthony

Wed 18 Jul 2012: Automatically marked as resolved.


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.07 secs.