Is your $ symbol part of a text entry in the cell, or part of the
formatting?
I think Pete was expecting the former, but your results suggest the latter,
so you may need to use VBA.
--
David Biddulph

"Jeffery" wrote in message
...
Pete... Thanks for the quick response, but I tried your formula and only
get
a blank cell for result.
I put the test data below in cells A1:A:5 then copied and pasted your
formula into cell A:6 and comitted the formula with (CSE) the formula
shows
the {} brackets but the cell result is blank.

Any Ideas??
Thanks


"Pete_UK" wrote:

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