Macro or formula- the same products, but a different sales color, looking for SUM

K0st4din

Active Member
Joined
Feb 8, 2012
Messages
488
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
Hello Everything, I'm asking you for some solution with my problem.
I turned the internet over, but I still can not find a solution to my problem.
I have a table in which column A2: to the end I have products in column B2: by the end I have sold pieces of these products. My problem is that for every product I have sold pieces that are yellow and others are colorless. I get some formulas or macros somehow to automate it, but so far I can not find a solution.
Perhaps shorter:
The same product - with sales for it in yellow and colorless (under defolt)
I'll also attach an example file.
Please for some help on your part, I just can not find any solution on the web.
Thank you in advance to everyone!
Please tell me where to attach the file so it's easy to download it !?
2018-08-01_183208Dt7QiN6TXhQPQZIs7pIv1533137549_thumb.jpg
[/URL][/IMG]
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,215,065
Messages
6,122,945
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top