Multiple ranges with the same name

[mitch]

I've got a number of identically named ranges that are all worksheet level in
scope. Is it possible to reference all of them at once on an overview
worksheet? I'd like to do a sumif with all of them at once in one cell.

 

[JBeaucaire]

If you can get the sum of the ranges from each sheet into the same cell on
each sheet (like AA1) then you could use a very low over-head method called a
3d-reference to sum all the cells AA1 in a range of sheets. Would that work
for you?

If all the values were in AA1, then the formula to sum all the AA1 cells on
5 sequential sheets would be:

=SUM(Sheet1:Sheet3!AA1)

They don't have to be named sequentially like that, they can be named
anything you want, you just have to have the first named sheet and the last
named sheet properly represented. It will sum the AA1 cells for those two
sheets and every sheet in between in your workbook.