I am looking for some help with formulas. I have a price list with multiple
lines between each price. If I use a formula I get $0 answers on the blank
lines. Is there anyway to only get answers where there is data? Otherwise I
have to manually clear all the cells in between.

$2.34 $2.81
$-
$-
$-
$-
$-
$1.58 $1.89
$-
$-
$-
$-
$4.86 $5.84
$-
$-
$-
$-
$3.76 $4.51
$-
$-
$-
$-
$-
$-
$2.16 $2.60
$-
$-
$-
$-
$-
$-