adding certain numbers

[Dusty]

How do I add only numbers in a column with a $ sign by them?
Example
2
$4
3
$6
4
$8

 

[Dave Peterson]

I think it depends on how those dollar signs got there.

If you formatted the cells (numbers formatted as currency), I'd use a helper
column with this formula in it:

Say in B1:
=cell("format",a1)
and drag down

=SUMPRODUCT(A1:A10,--(LEFT(B1:B10,1)="C"))

Adjust the range to match your data.

 

[BenjieLop]

This formula (array entered) will work for you too ...

=sum(if(left(A1:A6,1)="$",--right(A1:A6,1)))