690799_en-US

liliconcom

Conditional Counting of Columns

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.

Statistics and AnalyticsRe: Conditional Counting of Columns - Status changed to: AcknowledgedRe: Conditional Counting of Columns - Status changed to: AcknowledgedRe: Conditional Counting of Columns

Hello! I will be acknowledging some of your requests. Adding this comment so you will know that these have already been read and entered into our system (at the time of the first acknowledgement), but for some reason they reverted back to the "New" status, which is inaccurate. 

Re: Conditional Counting of Columns - Status changed to: AcknowledgedRe: Conditional Counting of Columns - Status changed to: Investigating

Hello, thank you for submitting this request! I was wondering if this script does what you are asking for? 

result = 0;
(For Each( {value, index},
	{:col1, :col2, …},
	If( value < 50, result += 1 )
) ; result);

Re: Conditional Counting of Columns

Hi Sarah, Thanks for the script - not being a scripter I can't check if this works. I can't seem to attach for some reason so will send separately

Re: Conditional Counting of Columns - Status changed to: Acknowledged