SUMIFS with OR

[gberg]

I have the following formula to look for multiple criteria

=SUM(SUMIFS(TBL_GL_Coins[Debits],TBL_GL_Coins[GL Account],{"71.10.50000","71.10.50100","71.10.50200","71.10.50300","71.10.50600"}))

Instead of using the actual values (i.e. "71.10.5000", "71.10.50100", etc.) I want to reference the values in cells (i.e. Cell T1 = 71.10.50000)
When I change the "71.10.5000" to T1, the formula stops working. Is there a way to reference cells in this formula or is there a different formula that would work?

 

[Fluff]

Are all the values in one cell, or each value in it's own cell?

 

[gberg]

Each value has it's own cell (i.e. T1=71.10.5000, T2=71.10.50100, etc.)

 

[Sufiyan97]

IGNORE
Can you post what actual formula you are using while referencing cells?

 

[Fluff]

Ok, how about

=SUM(SUMIFS(TBL_GL_Coins[Debits],TBL_GL_Coins[GL Account],T1:T5))

 

[gberg]

=SUM(SUMIFS(TBL_GL_Coins[Debits],TBL_GL_Coins[GL Account],{$T$2,$U$2,$V$2,$W$2,$X$2,$Y$2,$Z$2,$AA$2,$AB$2}))

 

[gberg]

Fluff, thanks that worked!

 

[Fluff]

You're welcome & thanks for the feedback.