Multiple drop down list total over multiple tabs

Hi all

I have made a worksheet that I would liek to add dollar amounts from several drop down menu's from different tabs.

ie: Tab 1 I have a year to date list. I have made the drop down list so a person would pick a category # and then would pick from a drop down list the corresponding description for the item number.

Tab 2 to Tab 12 setup the same, but each tab represents a sales period (month) and with each week listed with the top 10 items in sales. I have the total per period working (adds up correctly the $ depending on the item number

=SUMIF(A4:A61,A101,C4:C61) A4:61 represent item numbers for the 4 weeks. A101 is from the drop down list item (this case shoes) ... the C4:C61 is the total sale for the 4 weeks..


but i'd like to be able to on Tab 1 calculate the year to date total from all the other drop down lists sales. So if a person chooses item 71 (shoes) it would show the total for the 12 periods .

is this possible?

Steve

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on "REPLY" then GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok so i took off several months and left 2 months and the Year to date tab

Anyone?????

thanks anyways

I have looked at you file and first observation is that your data format/layout does not easily lend itself to calculating cumulative totals. You have 4/5 weekly tables on each sheet plus the addition of summing over 12 periods.

On the period sheets a single table with a column for week number would be a better format to do any calculations. "Ideally" a single tab with ALL data is preferred but I recognise that there may be "logistical" reasons for having separate tabs.

Can/will you consider changing the format the period sheets into a single table?

lol i am a very very basic user of escel, just trying to do something for a friend.

if there is an easier way i am all for it.

I'll take a look later.

Where does the data originate (IATOP?) ?

I find the whole layout confusing: it would be "easier" to start with the base data rather what appears to be an extract of "TOP 10" items.