This array* formula will do it, assuming your data is in A1:A5:

=SUM(IF(LEFT(A1:A5,1)="$",VALUE(RIGHT(A1:A5,LEN(A1 :A5)-1)),0))

Adjust the cell references to suit.

*As this is an array formula, then once you have typed it in (or
subsequently edit it) you must commit the formula with CTRL-SHIFT-ENTER
(CSE) instead of the usual ENTER. If you do this correctly then Excel
will wrap curly braces { } around the formula when viewed in the
formula bar - you must not type these yourself.

Hope this helps.

Pete

Jeffery wrote:

I am trying to figiure out how to only add cells in a column that contain a
dollar amount.
EXAMPLE:

$12.00
$11.00
14.00
20.00
$10.00

$33.00 Total
Please Help