I am using hyperlinks on some price values on cell in Google Docs. So my cells look like this:
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?