ARRAYFORMULA Help

[Derek]

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.

[ThinhDinh]

Found one that works.

=ARRAYFORMULA(MMULT(FILTER(--(P2:AA2=TRUE),A2:A<>""),TRANSPOSE(COLUMN(P2:AA2)^0)))

Tell me if it works for your case. Only need to change P2:AA2 for each range of score you need.

Update: This was resolved using the formula above, Derek hit the comments limit so can not reply.