Total this column

[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

 

[Gord Dibben]

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

 

[Ron Coderre]

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)

 

[Dave]

Both solutions worked

thank you very much

Dave