Sort:  

If you have the cells already in General format, you can use them to create any formulas/calculations with them. For instance, this image shows a selection of cells that are on General format, as you can see at the bottom of the image, excel uses the selection to calculate sum and average.

Maybe I'm not understanding the question. I'm sorry.

It's simple. You try to import data from the coinmarketcap, and then try to use a cell with price data in a formula.

Coin Marketplace

STEEM 0.18
TRX 0.16
JST 0.030
BTC 68272.80
ETH 2645.15
USDT 1.00
SBD 2.70