MacOS – Numbers: Force a calculation

In numbers, SUMPRODUCT (range, range…) takes the following arguments:

range: A range of cells. range is a reference to a single range of cells containing values of any type. If string or Boolean values are included in range, they are ignored.

range…: Optionally include one or more additional ranges of cells. The ranges must all have the same dimensions.

So you'll need to set up a range to perform the initial calculation (and squaring) and then sumproduct two simple ranges.

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