Excel 2007 : sumproduct question

[budchevy]

I'm tracking sales month to month and trying to get a summary page together that will lookup every ID and return the id, amount bought and amount sold from each month to the summary page.

I will need it to recalculate every month and keep a running total when I load the sales figures. I thought sumproduct might be the best solution but it's way over my head and I've been butchering it for 2 hrs trying to get it to work.

I've attached a very small sample of the data. Thanks for any help you can provide.

Bud

[MarvinP]

Hi Bud,
Have you looked at Pivot Tables? See if this does what you are needing.

[budchevy]

Marvin,
I had thought about using a pivot table, but I was concerned due to the fact that the sample data I gave is about .05% of the actual data. Some months could have 12,000 lines of ID's.

Also, can I get an average of the % sold?

I can give it a shot and see what happens..

thanks for the help.

[MarvinP]

I think Pivots will get you there much easier than SumProducts and is easier after you get used to them.

If needed you can filter the ID's to show only the ones you want/need. You can also do Averages, Counts, Min, Max, and many more column calculations using pivots.

[budchevy]

Marvin,

thanks for the head start... I took your idea to a grander scale and after fooling around with it for a while I learned enough about the tables to get it looking decent.. I'm sure I will spend some more time tomorrow refining it..


Bud