Not sure you need INDIRECT...

=SUMIFS(Tableold[Decision to Accepted],Tableold[Created],">40359",Tableold[Business Unit],"*"&D1&"*"))

perhaps?

the "*" makes this a wildcard so that if any cell in Business Unit has within its string the item that is in D1, then it will count it.