The “countif” formula.
The above example of this formula will count up all of the “Yes” entries in the “W” column, from W1 to W1000.
Note that this cell must not be located within the number range mentioned in the formula; for instance, in the above example, it might be located in W1001 (if it was located inbetween W1 to W1000, it would create a circular reference).
=(B5&" "&D5&",,,"&E5&",,,"&F5&" "&G5&" "&H5&""&W5)
The above example of this formula will combine all of the cells mentioned into one cell. In two places between some cells, I have placed three commas, which will appear in the final view of the cell.
Note 1: To put the above formulas in WordPress, I used the “code” function, as otherwise the straight quote marks in the code would automatically convert to curved quote marks.
Note 2: [For the pedants out there]. Yes, yes, I know that the plural of formula is “formulae”, but modern dictionaries also say that “formulas” is acceptable too. Yay!