Sum Numbers with "-" in between

[da80th]

hi again,

I have the following data, numbers that has "-" in between them, and I want to add them up together using formula, e.g.

1-Jan-13 2-4-4-9-30
2-Jan-13 1-4-7-10-17
3-Jan-13 1-2-2-3-18
4-Jan-13 3-5-5-10-16
5-Jan-13 1-3-6-14-24
6-Jan-13 3-4-9-13-13
7-Jan-13 1-4-4-9-13
8-Jan-13 1-2-2-3-13
9-Jan-13 2-3-6-8-20
10-Jan-13 1-3-5-6-10
11-Jan-13 1-2-3-3-13


I need formula that add numbers from Jan 1 and Jan 2 together, then add Jan 2 to Jan 3 together...

thanks

[FDibbins]

why dont you use text-to-columns on column B, then you can play with the resulting values to your hearts content?

[Fotis1991]

One way could be this.

In C1 and copy down, this Array formula.

Please Login or Register  to view this content.

This will be a helper and hidden column(If you like)

Then in D1 and copy down, use this one.

=C1+C2

Change ALL the semi colons in my formulae to comma.

[Fotis1991]

................................