Suppose I have the following columns (below). (Column1 contains text and column2 contains numbers)
I want to sum all 1111, 111-111, 2222, 123 (and create a pivot table using a formula)
Is it possible with OO?
111-111 2222 2222 111-111 1111 123 |
12 14 3 28 13 7 |
Columns C and D show the result as follows .:
1111 = 18
111-111 = 40
2222 = 17
123 = 7