Excel: Sumif over multiple sheets

[oliviaF]

Does anyone know how to get sumif to work over multiple sheets?

I have information (models sold per sales member) stored in different sheets (1 for each month) and am trying to calculate the yearly total per sales member per model.
The problem is that the sheets are sorted by total number of sales, so the list order (sales members) changes month by month.

I was hoping to do something like:
=sumif(sheet1:sheet12, salesmember, data_range (sheet1:sheet12) )
but excel is not allowing me to do this.

Any ideas???

 

[SkipVought]

oliviaF,

You have TWO problems. The SECOND one you stated here.

Your PRIMARY problem is that you have similar data in MANY DIFFERENT LOCATIONS. You are making life difficult for yourself. You ought to put your efforts into consolidating your data into a single table one one sheet in one workbook (unless there are other mitigating circumstances) from which all sorts of reporting possibilities emerge and from which all sorts of maintenance and reporting problems fade.

If your data were so consolidated, you would not have the stated problem, for which I have no SPREADSHEET solution.

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}