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
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):
It basically runs a function which only takes one cell (in this case the