3 COUNTIFS

A Rose

Hi,

Is it possible to do 3 COUNTIFS ?

Count if column 1 contains value 1,

Count if Column 2 contains value 2

Count if Column 3 Contains value 3

any solution?

Thank you!

David A. Estupinan

As I am understanding, you want something like this then

=COUNTIFS([Column2]:[Column2], "Value1", [Column3]:[Column3], "Value2", [Column4]:[Column4], "Value3")

Please feel free to try it with your values and check if this works as you expect, I hope this helps,

David.

David A. Estupinan

Hi A Rose,

If by "possible" you mean to use three COUNTIF to make some kind of sum based on certain criteria, maybe something like this is what you are looking for:

=COUNTIF([Column2]:[Column2], "Value1") + COUNTIF([Column3]:[Column3], "Value2") + COUNTIF([Column4]:[Column4], "Value3")

Hope this was the answer you were looking for,

David.

A Rose

Hi @David A. Estupinan ,

That's Column 1 Plus Column 2 etc.

I want a total of how many cells in column 1 and 2 match those values, not +, but And!

Got it?

Thank you!

David A. Estupinan

As I am understanding, you want something like this then

=COUNTIFS([Column2]:[Column2], "Value1", [Column3]:[Column3], "Value2", [Column4]:[Column4], "Value3")

Please feel free to try it with your values and check if this works as you expect, I hope this helps,

David.

A Rose

Hi @David A. Estupinan ,

That worked!

Thank you!!