Please can we have a simple formula option to count the number of columns that have a certain value.
I have 16 columns of metrics and I need a summary column of positive results in the data table so that I can use this in graphs and models.
In excel the formula would be Countif(A2:P2,1) where 1 can be numeric or categorical.
In searching I can only find long complicated scripts - but lots of hits asking the same or similar thing. I have given up and exported the datatable to excel used the formula and pasted back in.
