How do I add only numbers in a column with a $ sign by them? Example 2 $4 3 $6 4 $8
D Dusty Oct 26, 2004 #1 How do I add only numbers in a column with a $ sign by them? Example 2 $4 3 $6 4 $8
D Dave Peterson Oct 26, 2004 #2 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.
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.
B BenjieLop Oct 26, 2004 #3 This formula (array entered) will work for you too ... =sum(if(left(A1:A6,1)="$",--right(A1:A6,1)))
