Total this column

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a column of numbers that look like this.

1805 (1591)
1351 (1078)
1318 (1117)
418 (394)
344 (306)
260 (247)
247 (226)
205 (142)
156 (139)
144 (109)
142 (117)
139 (122)

I want to total the part NOT in the parentheses. How do I remove the part
in parentheses OR total without removing.

Any help here will be appreciated.

Thanks in advance


Dave
 
One method.

Insert a column right or left of this column if you want to retain the original
format.

Copy the column of data to the inserted column.

Data>Text to Columns>Delimited>Next>Space>Next

Select the column with the parens and "do not import column( skip)"

Then SUM the numbers.


Gord Dibben MS Excel MVP
 
With your posted data in A1:A12

Try something like this:
=SUMPRODUCT(--LEFT(A1:A12,FIND(" ",A1:A12)-1))

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Back
Top