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

283 thoughts on “Excel Formula Assistance

  1. Acheter Tamoxifene citrate

    Please let me know if you’re looking for a article writer for your blog. You have some really good posts and I think I would be a good asset. If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link back to mine. Please send me an email if interested. Kudos!

  2. coronavirus 1 800

    how quickly can coronavirus change to fip , caused by a variant of the coronavirus – cat with coronavirus drooling not grooming : whats the difference between coronavirus and rsv .

  3. how to treat feline coronavirus

    structure based discovery of middle east respiratory syndrome coronavirus fusion inhibitor , middle east respiratory syndrome coronavirus mers cov – human aminopeptidase n is a receptor for human coronavirus pdf : nejm coronavirus sauid arabia .

Comments are closed.