Excel 2007 : Sumifs and Indirect

Good Afternoon,

I am trying to combine a sumif and an indirect and it isn't working!

I am counting and summing columns in my table - one of which (BU) holds more than one entry.

So far I have:

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

I am trying to sum the entries in the column 'Decision to Accepted' which are newer than 30th June 2010 which contain a Business Unit which is the same as in cell D1.

Thanks in Advance,

MoonWeazel

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.