Summing Numbers With Specific Values To The Left Of Them

**FuzionZero** · 02-12-2007, 05:57 PM

Hi guys im new here and I have a problem that if someone could help me with would make my job alot easier. At my work I am responsible for compiling a monthly report. Well I have to gather data from an Excel document and add up all the totals and then print them out. Well there are like 40+ worksheets and the (lets call them) items arent always in the same locations (along with the values) so i was wondering if anyone knows how i can sum up values from multiple spreads and can do so while still summing up each value that belongs to the same item. Ill attach a screenshot of what one of the worksheets looks like. And remember that not all of these things are in the same order as the other worksheets

**carsto** · 02-12-2007, 09:02 PM

Assuming your column headings are always the same,
try using a Pivot Table with Multiple Ranges
here's how
http://www.contextures.com/xlPivot08.html

If your columns aren't always in the same location, here's some code Antonio (antoka05) wrote for me to delete unnecessary columns and rearrange the remaining columns in a specific order
http://excelforum.com/showthread.php?t=588202

**FuzionZero** · 02-13-2007, 05:09 PM

Im pretty new with Excel (only started using it since I got this job a few months ago) and I am sort of finding this confusing. If someone could take a look at my attached spreadsheet and mabye do it for me (if its not to much work) then tell me how they did it or show me how i can just copy those results. Thanks in advanced. Oh and the final product goes on a new sheet at the end.

EDIT - Just to let you know Plan Type B and two Benefit Code columns are the "items", Card # is not needed, and QTY is how much of the items were made. And as you can see that not all items are in the same spot on all the sheets. Colums A, B, & C are 1 list. D, E & F is another, aswell as G, H and I (3 Lists Side By Side). Thanks!

EDIT - Ignore this attachment. Correct one is a few posts down.

**FuzionZero** · 02-16-2007, 11:07 AM

Im just bumping this topic. it seems that the Excel Forum was down awhile and im sure it was overlooked. So if anyone would mind helping me out on this it would mean alot to me. Thanks.

**starguy** · 02-16-2007, 12:09 PM

Originally Posted by FuzionZero

Im pretty new with Excel (only started using it since I got this job a few months ago) and I am sort of finding this confusing. If someone could take a look at my attached spreadsheet and mabye do it for me (if its not to much work) then tell me how they did it or show me how i can just copy those results. Thanks in advanced. Oh and the final product goes on a new sheet at the end.

EDIT - Just to let you know Plan Type B and two Benefit Code columns are the "items", Card # is not needed, and QTY is how much of the items were made. And as you can see that not all items are in the same spot on all the sheets. Colums A, B, & C are 1 list. D, E & F is another, aswell as G, H and I (3 Lists Side By Side). Thanks!

you can sum by using SUMIF function.
workbook you attached have no data in sheet named Jan06, if you put data in month sheet and attach here then it would be easier to implement the proper function.