Counting the number of variable columns that have non-zero values

kpgallagher_ppg — Wed, 06 May 2020 15:39:49 GMT

I have a table of formulations. The amount of each of 60 possible ingredients are listed in columns. Most of the formulations contain only 5-10 ingredients with the ingredient amount of all other columns being zero.

I would like to create a formulation column (without scripting) to count the number of non-zero ingredients.

The way I was thinking to do this is to sum conditional statements for each ingredient. This shows the first 4 ingredients:

Is there a quicker/easier way to do this without having to create a string of 60 if statements?

Re: Counting the number of variable columns that have non-zero values

txnelson — Wed, 06 May 2020 16:01:05 GMT

You can shorten the code up to

sum( :T400>0,:T402>0,:T404>0,:T405>0)

topic Counting the number of variable columns that have non-zero values in Discussions

Counting the number of variable columns that have non-zero values

Re: Counting the number of variable columns that have non-zero values