VBA code to sum up values in column B depending on column A

I'm hoping someone can help me write some code.

What I want to do is sum up the values in column B depending on the category in column A. Let me give an example of what my spreadsheet looks like

A--------B

HOLSA--50
HOLSB-- 25
HOLSC---20
SICKA---10
SICKB ---10

In column C I'd look to group these up by the first 4 letters so it just says HOLS 95 and SICK 20.

There's quite a few of these and they will change but they will always be grouped by the first 4 letters as they will always be the same for each category so I'm guessing I'll somehow need to use a wild card.

Is anyone able to point me in the right direction with this.

Thanks

Hi,

There's no need to write a VBA code for this. Put the following formula in the correct row in column C and copy it down till the last row.

Formula:

Please Login or Register  to view this content.

Make sure to adjust A1 and B1 to the correct row number.

Greetz,
Tino XXL

Here is non-vba solution

I was going to write it in VBA so someone who can't use Excel can just push a button. I guess I can just record a macro that applies this formula to the relevant cells

dan27, with my solution he doesn't need to push button. It will automatically provide solution. Just enter new values

This is good but it misses out occasions where 0 is the value and only returns the first 4 letters of column A. Ideally I'd like the ouput to be set format.

i.e

Holidays 95
Sickness 20

And so on

Thanks kindly for your help

Can you upload example workbook with your inputs and desired output?

Sure. Columns A and B are a copy and paste from my pivot table. Columns G&H are desired results.

Thanks again for your help.

I think you need to define new table that will compare your names (don't worry, you would need to define those too if you creating VBA because I don't see logic to extract this out).

I am happy to define them in VBA. I just see this now become complex and leaves too much room for error for someone who doesn't know what they're doing.
If you're able to write in VBA then I can do all the defining if you can just do me a template.

Thanks