Forum Discussion
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 ...
=SUMIFS(Outgoings!E:E,Outgoings!D:D,B2,Outgoings!M:M, "Yes",Outgoings!N:N,"*") Its returning 0. Any ideas?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar So H is the issue. there is data in D but its not counting it.