Need a complex formula to categorised and return the value by division

I'm not sure whether this can be done in excel so i posted the question here.TABLE.jpg

The main problem is the 3 BARCODE A111, A222 and A333.
These barcode will return quantity as 1 in any main id.

However, when these 3 barcodes are parked under APPLE there will be a special requirement on how the quantities to be calculated.

For SO1111, Apple is captured under Fruit column, with all 3 barcodes above captured as well, the quantity is returned with 1 divide by 3 equals to 0.33 each.
For SO2222, since only 2 of 3 codes present, 1 will be divide by 2 and return 0.5 instead.
For SO3333, since it's not appleso all value will be returned as 1.

By merely formula is this doable?