I am trying to put a formula together that will sum up a Total of Ancillary Revenue based on a List.

Now I could do it by adding up all the values in the cells like my code below (where my list of possible values is in Cell $S$61 downwards......

Code:

```
=IFERROR(CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Ancillary Revenue]","[AncillaryInfoTable].[Ancillary Description].&["&$S61&"]",Slicers1),0)
+IFERROR(CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Ancillary Revenue]","[AncillaryInfoTable].[Ancillary Description].&["&$S62&"]",Slicers1),0)
```

.....but was wondering if it's possible to reference a Named List in the formula instead of the static cell references, as there may be as many as 8 values. Something like this..

Code:

`=IFERROR(CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Ancillary Revenue]","[AncillaryInfoTable].[Ancillary Description].&["&NamedList1&"]",Slicers1),0)`

Thanks

Chris