I am trying to figure out a way to create a sum for named ranges using a wildcards as part of the name. The data I am working on has specific parameter data for different sites. For instance, the defined name ranges look as follows:

Plant1_Downtime
Plant2_Downtime
-
-
Plant50_Downtime

I would like to sum all of these ranges without having to enter individual defined names into a SUM equation. Ideally I'd like to be able to do something like the following:

=SUM("*_Downtime")

Unfortunately this gives me #VALUE error.

Does anyone know of a way to accomplish this?