=SUMPRODUCT(--(LEFT(A1:A5,1)="$"),--(SUBSTITUTE(A1:A5,"$","")))

The cells must be formatted as text. You can check this by selecting the
cell and looking at the formula bar. If A1 ($12.00) looks like $12.00 in the
formula bar, then it is formatted as text. If A1 ($12.00) looks like 12 in
the formula bar, then it is formatted as currency. If you enter $12.00 in a
cell without first formatting it to text, then it will format the cell as
currency. To avoid this either format the cell as text before entering data,
or preced the entry with an apostrophe like this '$12.00

I'm assuming you are having trouble with Pete's formula because of this issue.

"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