Hi,
I struggle with a file of mine: I have one sheet per alley (all similar) for a store. I want to sum up each department on its specif sheet and "A1" has the name of the department on every sheets).
If I create a sheet "Fruits & veg" with its name in "A1" too, what should I do to have all "A2" added if its belongs to this department?
I tried =sumif(sheet1:sheet99!A1;A1;sheet1:sheet99!A2) but I got a value error. I guess range has to be on a single sheet.
Note that I have a macro creating the sheets of the alleys and could therefore use a macro to sum up the department if I knew how. Unfortunately the name of the alleys change for each store (the macro use a list of alleys to create the sheets) but I should be abble to sort it out if I could understand how to ask excel to sum A2 of the sheets if their A1 is similar to A1 of my active sheet.
Thank you in advance for your input.
Kamolga
I struggle with a file of mine: I have one sheet per alley (all similar) for a store. I want to sum up each department on its specif sheet and "A1" has the name of the department on every sheets).
If I create a sheet "Fruits & veg" with its name in "A1" too, what should I do to have all "A2" added if its belongs to this department?
I tried =sumif(sheet1:sheet99!A1;A1;sheet1:sheet99!A2) but I got a value error. I guess range has to be on a single sheet.
Note that I have a macro creating the sheets of the alleys and could therefore use a macro to sum up the department if I knew how. Unfortunately the name of the alleys change for each store (the macro use a list of alleys to create the sheets) but I should be abble to sort it out if I could understand how to ask excel to sum A2 of the sheets if their A1 is similar to A1 of my active sheet.
Thank you in advance for your input.
Kamolga
