I am using hyperlinks on some price values on cell in Google Docs. So my cells look like this:
=HYPERLINK("http://www.site.com/item","$25.00")
I am trying to perform a SUM
operation on a bunch of these cells but it was always returning 0. After investigating a little, I realized that it was because the value of the cell is not in fact the amount, but the hyperlink function. Is there a way to accomplish what I want while keeping the hyperlinks and the price in the same cell?