SOLVED

How to use text for a cell as part of a formula

Copper Contributor

Hi,

 

Can someone help with an excel formula?

 

I'm trying to add a dynamic text within a formula so the named range in my formula changes, I have a list of named ranges in my data table, and on the dashboard have a dropdown list of the named ranges, the formula is =SUMIFS(SCASCoreTotal,Month,E2) where SCASCoreTotal is the named range, I want this to refer to column D and as I drag the formula down it will change the named range to the new named range, i.e. the next named range is SCASActualTotal so this will some all the values in that month for actuals, or whatever is in the next cell which reflects the named range in the list.

 

I hope this makes sense.

 

Regards Darren

2 Replies
best response confirmed by darrenbull (Copper Contributor)
Solution

@darrenbull 

Perhaps like this:

=SUMIFS(INDIRECT(D2),Month,E2)

Thanks @Riny_van_Eekelen that's perfect!
1 best response

Accepted Solutions
best response confirmed by darrenbull (Copper Contributor)
Solution

@darrenbull 

Perhaps like this:

=SUMIFS(INDIRECT(D2),Month,E2)

View solution in original post