Sum Data from Multiple Columns into one table

[landj1995]

How can I take the information in the yellow columns and put into one column with the sum of the green columns and be able to show sum by month for each part number.
Example: Final result would show
YEAR/MONTH (Listed in Column C as Year/Month/Day, only need Year and Month)
Column 1: Part Number (all listed in yellow columns)
Column 2: Total Requirement (all listed in green columns)

 

[alansidman]

Cannot manipulate data in a picture. Please supply a sample file of 8-12 records using XL2BB and then mock up for that data a solution so that we understand your exact requirements.

 

[landj1995]

Cannot manipulate data in a picture. Please supply a sample file of 8-12 records using XL2BB and then mock up for that data a solution so that we understand your exact requirement

 

[landj1995]

Cannot manipulate data in a picture. Please supply a sample file of 8-12 records using XL2BB and then mock up for that data a solution so that we understand your exact requirements.

I am not able to get XL2BB to work, what are other options on sending a file?

 

[alansidman]

You can post your file to Dropbox.com or Box.net or some other similar site that does not require a subscription or sign up to use. Also, you can share a file that is in OneDrive since you are on Windows. You would then share the link to one of those file locations.

 

[landj1995]

You can post your file to Dropbox.com or Box.net or some other similar site that does not require a subscription or sign up to use. Also, you can share a file that is in OneDrive since you are on Windows. You would then share the link to one of those file locations.

SumMaterialNumbers.xlsx
Here is the link for the dropbox file.
landj1995

 

[alansidman]

What quantity are we summing, Box Wrap?, Pallet Wrap?, Pallets? Your request is too vague for a response at this time.