I am trying to total a score with all the stars that are checked to count as 1 score each.

Wendy Gaines · 09/21/23

My formula is not calculating with the columns and a , 1. I think I am missing something.

Eric Law · 09/21/23

Hello @Wendy Gaines It would be good for you to post your formula so we can help with that. Try this formula.

=COUNTIF([Family Support]@row:[Time at Home]@row, 1)

Wendy Gaines · 09/21/23

I think it is as you said. I am missing the @row behind each.

Wendy Gaines · 09/21/23

I tried this and still is not working.

Razetto · 09/21/23

@Wendy Gaines See if this works out =countif([family support]:[time at home], @cell=1)

Answers