COUNTIF in columns

[kyrpav]

I would like to do a Countif(RANGE;criteria)

where the range is one row but different columns. Columns also are not one next to the other. and the creteria is some text like:

COUNTIF(A3:K3;"R")

In this case excel would have skip all columns that could be numbers etc.

Is this possible with DAXs so i can create a new column in the table with a function to calculate each row?

[Icey]

Hi @kyrpav ,

Is this problem solved?

Best Regards,

Icey

[kyrpav · Accepted solution]

Solved the problem with nested ifs so i could get for each column one value based on text. This was set to a variable.

Also each column was calculated in a variable and then i just sum all variables

[Icey]

Hi @kyrpav ,

Please refer to this post: Counting Text Values in Multiple Columns.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

Hi @kyrpav ,

Have you thought about COUNTX function ?

Ricardo

[kyrpav]

i do not think it is this. If you have a table :

col1	col2	col3	col4
R	G	B	R

What i want is to by a function that passes all columns to count. 

So by CountIF(A2:D2;"R") = 2

and like this then i can count for each case seperately and sum up.