SUMIFS with Multple Criteria that point to a Cell

[jaredj34]

Not real sure how to word this but I was able to create (thanks to posts on this site) the following formula.

=SUM(SUMIFS(January,Acct,$AE54,UnitCode,{120,220,320,420,620}))

Now I would like to take one step further. I would like to replace the {120,220,320,420,620} with a cell reference of the same information. I would like to avoid add an array of static values into 1000s of formulas.

Any Ideas?

Jared

 

[jaredj34]

What do you have in B5?

B5 is January and then on my Data Table I have a Named range of January. The Indirect function allows me to call the right sum range by just using a cell reference.

Thanks again.

 

[Aladin Akyurek]

B5 is January and then on my Data Table I have a Named range of January. The Indirect function allows me to call the right sum range by just using a cell reference.

Thanks again.

Yes, thanks.