Finding anything in cell

Hey guys    I'm trying to do a sumifs.    This is the basic I am using sumifs(B:B, C:C,A1, D:D,"Yes" E:E (if anything is written in any cell regardless of what it is).  the last bit is what I'm ...