I have a spreadsheet with invoice amounts. Each amount is a link to the given invoice. Can I use
value() (or any other functions) to somehow use the displayed value for
sum() (and not the actual hyperlink)?
Update: Sample Spreadsheet
Yes, but you have to use an
Array Formula, like this:
I took the liberty to edit your Sample spreadsheet.
You can write
and press ctrl + shft + enter to make it an Array formula.
About array formulas (from here):
"Single-cell" array formulas let you write formulas with array inputs, instead of array outputs. When you wrap a formula inside an =ARRAYFORMULA function, you can pass arrays and ranges to functions and operators that usually only take non-array arguments. Those functions and operators will apply to each entry in the arrays one at a time, and return a new array with all of the outputs.
It basically runs a function which only takes one cell (in this case the
value-function) and runs it on every cell in the range.