Need formula to Populate Results of Dropdown "Check" Boxes

Hello- First time posting here and I am very much a novice at excel formula writing but I am creating an automated form that consists of a series of dropdown boxes that can be "checked". If one primary indicator box is checked than it meets overall criteria as "Yes". I have a working formula for the yes or no to populate based on the primary indicator checks. However, I have a list of secondary indicators that must have two or more check boxes to qualify as a "Yes". I am trying to find the correct way to write this formula and integrate it with the existing primary check box formula.

My results box has the existing formula that looks like this:

=IF(OR(A23="X", A24="X", A25="X", A26="X", A27="X", A28="X"),"Yes","No")

I am just looking to add another column of boxes (cells AB23 through AB31) but need the "Yes" or "No" to be contingent upon two or more of only that once specific column of check boxes being checked.

I hope my problem is clear and I greatly appreciate any help I can get!!

Thanks both of you for help. I think I'm getting closer but for some reason whenever I type the formula to contain a range and use a colon, I get some kind of error message or it will work but select multiple cells/boxes at once. I have uploaded the page I am working on and I have highlighted the box with the formula I am working on. Right now it shows a listing of all the cells that it is dependent on instead of the range.

I tried both the >1 and the >=2 formula additions for my secondary indicators and was given an error message about too many functions at once. Maybe a look at the form will help illustrate the issue a little better. Again, I really appreciate your time!!

The error message appearing says "Value entered not valid" when I input formulas shown above in replies. I changed the data validation to custom to accept the Yes and No as written but still no success. Any idea what the problem could be here. Again, spreadsheet with highlighted area of concern is attached. Thanks!!

I am looking for a formula to be entered in the cell on the worksheet. I toyed with the Data Validation tab since it was reading something about it in the error message and thought it might have to do with the drop-down option.

Here's the sheet again in a smaller document. The highlighted cell is the one where I am trying to write the correct formula. The cell locations have changed from what I typed earlier because it was cut from another page but the first two columns of blank boxes are the primary fields and the last column is the secondary field. At least one primary or two secondary fields need to contain an "X" for the highlighted cell to ="YesUpload question_reduced.xlsx"