Forum Discussion
COUNTIF in columns
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?
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
5 Replies
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.
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.
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
