Sum multiple defined named ranges using wildcards.

There is not a way to operate on names using wildcards, but there may be another way to meet your goal. How is your data organized, and how do these names refer to data? For example, if each name refers to the same range on a different sheet for 50 different sheets, there may be a way to do this other than by using the names.

Also, do you need to do this for other names, or just the one?

It would be very helpful if you could attach your file.

Thanks for the reply 6StringJazzer. Unfortunately I can't include the file as it has some company data in it. However, I will provide a little more detail in response. The data is pulled from a SQL Reporting Services cube into a pivot table on a single worksheet. All of the data is located on this single worksheet and the named ranges apply to individual columns. I did find several solutions for using the same named range on different worksheets but that won't work for me. I searched several sites before posting this but couldn't find anything that would help. Must be because it is not possible to do. At least not without a macro......

I can't think of a way to use wildcards.

However, you could try this method:

=SUMPRODUCT(SUMIF(INDIRECT("Plant"&ROW(INDIRECT("1:50"))&"_Downtime"),"<>0"))

NB...

If the names are dynamic names created using functions like OFFSET then this will not work!

You're welcome. Thanks for the feedback!