This is a total from sheet 1 col how can i paste to a total sheet on
another sheet I tried but just get the fomula under the number.
(e1,e,2,e3,3,4) instead of the sum

$12,217.94


$5,418.92
$718.02
$1,086.33

$7,223.27


$2,952.62
$25.00
$692.51
$304.00
$48.52
$327.53
$-
$382.10
$-
$304.51
$223.98
$293.88
$851.36
$73.00
$-
$152.01
$172.50
$-
$156.11
$20.00

$6,979.63
$28,557.64
$28,622.15
$155.00
$39.04