Extracting certain parts of a text in a cell

Hi!

I have a small problem. At the moment I do this manually, but the margin for error is too high for me to be doing this, as the numbers used based on the extraction is highly important.

Basically, I am looking up a "project name" where I have lets say;

Each sub category inside each project.

AB-B05789-11-11-11-11
AB-B05789-11-11-11-12
AB-B05789-11-11-11-13
etc...

each of these projects has a price column to the right of it.


After each unique project there is 1 line gap, where I currently write the beginning like this; AB-B05789 and I do a SUM(A1:A3) in the cell to right. This way I can keep control of each project, and the revenue connected to it.

Further on, I then extract from another report where I list all the projects connected to our firm. I controlcheck what we have registered as revenue, compared to what each project manager has done. This way we find out if anyone forgot to input their revenue on the specific project.

The way I do this currently is by using a VLOOKUP on exact matching values.

I would like a formula (if possible) that gives me auto function on the SUM and another one that lists "AB-B05789" meaning, it lists everything until the 2nd "-". The project can also have other names, such as B-4550, meaning it isnt always two letters in front. But it is always "-" that makes a new subcategory. "AB-B05789" is the highest point in the hierarchy.

Here is an example that probably makes it easier to understand.

Thanks.

-nicdyb

EDIT: H15 and H26 is supposed to be SUM functions that I manually put in. The formulas somehow disappeared.