Countif with AND statement

[jimjaix]

Hi I currently have a count statement below, I always want to add an AND function let's say Countif(CC4,">=4" AND CB3>=3) something like that, how can I get this to work?

=SUM(COUNTIF(CC4,">=4"),COUNTIF(BX4,">=4"))

 

[Richard Schollar]

Hi

Why are you using COUNTIF on only a single cell range?

You can use multiple criterias by using SUMPRODUCT:

=SUMPRODUCT(--(Range1>=4),--(Range2>=3))

 

[jimjaix]

Hi its not a single cell, I just pasted one countif statement, I am doing a selected cells with the countif but I don't know how to add another criteria into that countif

Hi

Why are you using COUNTIF on only a single cell range?

You can use multiple criterias by using SUMPRODUCT:

=SUMPRODUCT(--(Range1>=4),--(Range2>=3))