Hi everyone, looking for someone to help out with an arrayformula. I have 21 different nutrients that have anywhere between 7-13 questions in different columns. The user will tick a checkbox if the question applies to them making it a TRUE value. I need to count the total “TRUE” for each nutrient and have the spreadsheet formula move down each row giving me the total count as it moves down the list of new users.
Here is an example using COUNTIF TRUE but I can’t use this as Glide only will work with an ARRAYFORMULA.