Excel formulas

=COUNTIF(W1:W1000,"=Yes")
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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s