how to sum values in array?

[Danila]

Hi!
Need your help on the following task - there is a table with data like this :

Articles Values given
5.1 article 1
5.1.1 article 6
.... ....
and a table to aggregate data :
article Sum
5.1
5.2
... ...

so i need to sum 5.1 and 5.1.1 values for 5.1 etc (please check the file included)
the question is is it possible to be done by formulas? please note that article names are text fields...
WBR,
Danila

 

[Hui]

Danila

Firstly, Welcome to the Chandoo.org Forums

Cell C3: =SUMPRODUCT((LEFT($E$3:$E$12,LEN(A3))=A3)*($F$3:$F$12))
Copy down