Get the DisplayValue of a Hyperlink

Bravado

I have a column of currency values that are hyperlinks to receipts. I want to total the column but the SUM function does not recognize the displayvalue (the currency amount). How do I Get the DisplayValue of a Hyperlink?

Thank you in advance

Leibel S

@Bravado

when you have the hyperlink it converts it from a number to a text, you need to convert it back.

Add another column with the below formula:

=VALUE(SUBSTITUTE([YourColumnName]@row, "$", ""))

then run your SUM function on this new column