Sum values in column based on variable values in 3 other columns

**Winon** · 05-31-2012, 01:25 PM

Hi all,

I don't know if this can be done with DSUM or SUMPRODUCT or whatever. The attached WB shows what I have on Sheet1, with what I need to accomplish on Sheet2.

Any help will be much appreciated

**dilipandey** · 05-31-2012, 01:40 PM

Hi Winon,

See the attached file and let me know if this helps in solving your purpose. thanks.
Columns Data Sample.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**Winon** · 05-31-2012, 02:23 PM

Hello dilipandey,

Thank you for your help!

Are you a Magician? The Totals per Colour Column seems to check out o.k., but not the Sub-Totals.

I have changed the formulas in F6 to G7, to give you an idea. The thing now is to find the right formula to get the correct Sub-Total.

That is what I am having an issue with.

Thank you

**dilipandey** · 05-31-2012, 02:46 PM

I am not a Magician

Just a Excel lover ..

would suggest you to sort your data.. first on column Product Range and then on color and let me know if this works .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Winon** · 05-31-2012, 02:56 PM

Hi DILIPandey,

Unfortunately It is important to keep the four columns of Data in Line With the Job No., Product Range, Color and Qty. Sorting only one or two of tose columns will distort the Data integrity.

**dilipandey** · 06-03-2012, 10:13 AM

Hi Winon,

After Sorting and applying formula, you can copy paste the results and then you can re-sort your data as per the Data Integrity ..

Regards,
DILIPandey

<click on below 'star' if this helps>