I'm trying to write a formula that is infinite to add all new data from a Google Form. The snag is that I'm turning text into numbers.

For example, I want the formula to search the column for the text "Youth 1" and add up all occurrences. Then I will do the same for "Youth 2," "Youth 3," etc. in other cells.

Here's what I have:

=(IF ('Form Responses 1'!B2 = "Youth 1",1,0))+(IF ('Form Responses 1'!B3 = "Youth 1",1,0))+(IF ('Form Responses 1'!B4 = "Youth 1",1,0))

This works, but is there something I can do to not repeat this formula over and over again? I tried

=SUM (IF ('Form Responses 1'!B2:B1000 = "Youth 1",1,0)) and other variations of that, but nothing seems to be working.

Any help would be appreciated! Thank you!