sum 50/50 split from pre existing category

[darkbluecat]

Hi,

I've had a look through past posts and can't find anything relating to what I'm trying to do or where to start with it.
So I have five categories, including an unidentified category (which relates to one specific supplier category in another column in my raw data), so in these 5 categories, I want to do the sum of the unidentified stuff moved into an even 50/50 split into other pre existing categories (e.g. if unidentified, sum is split 50% one category, 50% the other category).

I'm just not sure what calculation/action would work, but it needs to be automated.

There's a total 144 cells in the unidentified category- is there a way to sum 72 of these into one pre existing category and the other 72 in another pre existing category?

Sorry, can't provide any more information as work stuff.

 

[maabadi]

Please Upload Example file & Desired Results with XL2BB ADDIN(Preferable) or upload at free hosting Site e.g. www.dropbox.com , GoogleDrive or OneDrive & insert Link here.

 

[darkbluecat]

Sorted it now thanks

 

[maabadi]

Glad you can do it.