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
=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