Numbers: Can I highlight the row and column of the selected cell

Another way to do this without clicking in each cell would be to use the =HYPERLINK() function.

Here are some steps:

• Add a second column (Let's call it B)
• In the adjacent cell, add a formula like this: =HYPERLINK(A1)
• Drag the formula down

Provided that the original URL's are valid, this will convert them.

You can even add your own text in place of the URL. (see screenshot)

So, given column A has a long list of URL's starting in cell A1, then in B1 enter:

=HYPERLINK(A1,"Clickable Link")

One could even parse the original URL to get just the human readable part using MIDDLE() or similar.

Hope this helps!! Sample Numbers Formula for Hyperlink

You need the COUNTIFS() function.

So in this case:

=COUNTIFS («gun range», true, «Firearm», "Pistol")

Accounting for ; delimiters:

=COUNTIFS («gun range»; true; «Firearm»; "Pistol")

From the help:

The COUNTIFS function returns the number of cells in one or more collections that satisfy given conditions (one condition per collection).

COUNTIFS(test-values, condition, test-values…, condition…)

test-values: A collection containing values to be tested. test-values can contain any value.

condition: An expression that can include comparison operators, constants, the ampersand concatenation operator, and references. The contents of the condition must be such that the result of comparing the condition to another value results in the boolean value of TRUE or FALSE.

test-values…: Optionally include one or more additional collections containing values to be tested. Each test-values collection must be followed immediately by a condition expression. This pattern of test-values, condition can be repeated as many times as needed.

condition…: If an optional collection of test-values is included, an additional expression that results in a boolean TRUE or FALSE. There must be one condition expression following each test-values collection; therefore, this function will always have an odd number of arguments.

Notes

Each value in test-values is compared to the corresponding condition. If the corresponding values in each collection meet the corresponding conditional tests, the count is increased by 1.