Sumif over multiple spreadsheet in same file

[Patish]

Hi Ya'll

I have a file made up of sheets generated, on demand, from a template in the same workbook. The copies generated always appear to the right of the template, the newest always appears last. In the formula =sumif(range,criteria, sum_range), the Range is always in column A on sheets generated from the template, the Criteria is always item numbers of a list of items in column B in a sheet called "FB Store Item List" and the sum_range will change to whichever info I need: The sum_range may appear in column C,D,etc on the generated sheets. The Range must always include sheets generated from the template.

I need, for example, to sumif all items in the workbook with the same item number on the generated sheets.

If it's difficult to follow I can always attach an example.

Thanks

Patish

[Punnam]

Hi Patish ,

Please provide attachment, with sheet showing before and after, for better understanding.

[Punnam]

Hi Patish ,

Please provide attachment, with sheet showing before and after, for better understanding.

[Pepe Le Mokko]

Well known problems with lots of answeers on the Net. One of them http://www.get-digital-help.com/2011...ltiple-sheets/

[Patish]

OK, I've attached an example. Just to add: The template is "The Recipe Card". Press the Smiley to select the items in the left window of the Recipe Manager. The selected items add to the right hand window by pressing the add button. To generate the recipe by pressing the little Chef above the Add button. The new recipe appears furthest to the right, the selected items appear on the recipe sheet together with the item numbers.

What I explained in the message above I think is enough as to what I need.

Thanks

Patish

[haninam]

Hi everyone,
I am Haneefa N from India lived in Saudi arabia, I looking for to easy way to handle excel software and i need help from all members and what with me, will post on this...

[Patish]

Hi Haneefa

Hope all is well in Jedda.

With all due respect I do not understand what your request has to do with my issue. Or am I missing something?

Regards

Patish

[Patish]

Punnam and Pepe

G'day to you.

I have attached a copy of the file. I went into your link, Pepe's. It' not exactly what I need. As I add sheets to the right of the template I need the new sheets to be included in the sumif formula on the "FB Store Item List" Tab. The formula in the link is if the number of sheets are static.

Thanks

Patish

[Punnam]

Hi Patish,

King Solomon Grill Menu 2014.xlsm

I had managed to find the solution for the quantities

This solution has some limitation which required some manual work .

1) As and when u have added a new Recipe it is necessary for you to run the macros to get the name of all sheets in the workbook & at the same time you should update the "List" range in name manager tab.
2) I have used Sumif, Indirect, Sumproduct function to achieve the quantities.As u have about 2000 items in the FB sheet the recalculation time to calculate the data is delayed .
3)For column D is the data is in Column C in FB Sheet

Find the attachment if the have Solved please rate me.
Ravi Kumar