Excel Formula Assistance

I’m having trouble writing a formula for my excel file. I want the excel to read the Quantity for each model and instead of keeping them separate it combines them as a set and reduces the number for each single model. 

Here’s an example:

Model 1 – 4 QTY

Model 2 – 4 QTY

Model 3 – 4 QTY

Set of 3 – 0 QTY

 

Then it’ll will read that you can combine all numbers to make a set so it should return

 

Model 1 – 0 QTY

Model 2 – 0 QTY

Model 3 – 0 QTY

Set of 3 – 4 QTY

 

Also I’d like it to combine as much models as possible for example:

 

Model 1 – 7 QTY

Model 2 – 2 QTY

Model 3 – 5 QTY

Set of 3 – 0 QTY

 

then it returns:

 

Model 1 – 5 QTY

Model 2 – 0 QTY

Model 3 – 3 QTY

Set of 3 – 2 QTY

 

Any help will be greatly appreciated.

By: Mena

112 thoughts on “Excel Formula Assistance

  1. tips gokkasten casino

    gokautomaten traduction , betalen met je telefoon casino – nieuwe gratis gokkasten : gratis gokken simply wild .

  2. testautomatisering strategie

    nieuwe bonus code online casino 2020 , geld verdienen online casino – casino strategie verdoppeln : casino app android echt geld .

  3. tijdelijke vestiging holland casino groningen

    gratis gokautomaat spelletjes , welke online casino is betrouwbaar – holland casino amsterdam west la guardiaweg 61 1043 de amsterdam : gokken op fruitautomaten .

  4. gratis jumanji slot spelen

    gratis casino spelen , start speelautomaten – gokken zonder storting : kroon casino mobiel .

  5. beste welkomstbonus online casino

    jokers wild gokkast online , fundering storten zonder bekisting – holland casino amsterdam eintritt : roulette holland casino eerlijk .

  6. gratis fruit gokkasten spelen

    leovegas beste slots , blackjack holland casino kaarten tellen – uitbetaling online casino belasting : bingo automaat holland casino .

  7. grand slam casino gokkast

    holland casino amsterdam niederlande , play store casino echt geld – casino in utrecht : simply wild gratis gokkast .

  8. speelautomaat 7 letters

    holland casino breda jackpot , gratis spelen speelautomaten – speelautomaten gratis spelen : nieuwe casino tiel .

  9. gokkasten hacken gratis

    geld verdienen met casino , casino registratie bonus – roulette gratis bonus zonder storting : circus casino betrouwbaar .

  10. casino online legaal

    spelletjes van de casino , geld verloren in casino – gokverbod holland casino : gokkasten tips en trucs .

Leave a Reply

Your email address will not be published. Required fields are marked *