Completed COUNTIF

[Frank Bacchus]

Hi:

I would like to Count the occurrences of column A only if column B = “ABC” and column C = 123. What’s to formula to do this?

thank

frank

 

[Shteven]

Formula to count the occurrences of B="ABC" and C=123:
=COUNTIFS(B:B,"ABC",C:C,123)

This formula does not consider what is in column A.


Formula to count the occurrences of B="ABC" and C=123 and A=NOT NULL:
=COUNTIFS(A:A,"<>"&"",B:B,"ABC",C:C,123)

Including this just in case you did want to consider only rows in A with values.

 

[Frank Bacchus]

Thanks alot. Appreciate it.