You do that with an array formula
Jesus A. Vargas Espinosa-Mireles
m. +52.555.505.1571
o. +52.998.478.0706
w. lowcode.agency
a. Blvd Kukulcan Km 9.5, ZH, Cancun, 77500
What formula did you use before?
This is what I have now for the row 2 for Biotin:
=COUNTIF(D2:N2,TRUE)
Then I had it going down to infinity
The screen shot shows the next formula for Calcium. All the questions are to the left and I wanted to have the results of TRUE all together so I can see the scores.
