SUM cells with same content and multiplied by quantity of each

[t.regi]

I have no idea if this is even possible but im trying to figure out how to make my life a whole lot easier. Basically i need a formula that will look at the message content on a seperate sheet (Data sheet on the attached example) and multiple by the volume of the message type to return a value on a seperate sheet.

The problem i have is our messages appear in the data as seperate lines based on the entire message content, with a quantity of how many times that exact message was sent on a day DESPITE there being many variations of a message, they may all only equate to 1 or 2 actual message types.

In the example you will see the Data tab showing Example message 1, Example message 1.1 etc. All of the Example message 1-1.5 are actually the same message type (same applies to Example message 2) and i need to be able to have formula that groups and counts these to return a value by message type * by the quantity per day. So in the example, Example message 1 would return a result of 10 on the main sheet.

Is this possible? Can it be done?

[FDibbins]

Try this, copied down...
=SUMIF(Data!$B$1:$B$12,After!A2&"*",Data!$A$1:$A$12)

[t.regi]

Can't get that to work... Is there something perhaps that could return a result of message code 0021 whenever there was a message type consisting over Example message 1 - 1.5? Is that possible? And from there, multiple each that has a message code of 0021 by the message type volumes?

Sorry if this isnt making sense, its difficult to even explain.

[FDibbins]

It worked fine for me with your sample data...

	A	B	C
1		Yours	Mine
2	Example message 1	10	10
3	Example message 2	15	15

C2=SUMIF(Data!$B$1:$B$12,After!A2&"*",Data!$A$1:$A$12)

THis was on "After" sheet

[t.regi]

I get 10 for each. How do i vary it for different messages? ie how is it different to get 15?

[t.regi]

sorry, drag drop worked. Thanks. I will try and apply this.