Forum Discussion
Sumif between dates
This is what I was trying, but getting an error. =sumif(Table1[Net to Office],Table1[Close Date],">="&CashFlow!C2,Table1[Close Date],"<=&CashFlow!C3) On 1 tab I have date and net to office, see bel...
For 2 0r more conditions, you need SUMIFS instead of SUMIF.
=SUMIFS(Table1[Net to Office],Table1[Close Date],">="&CashFlow!C2,Table1[Close Date],"<=&CashFlow!C3)
HansVogelaar such a small thing but makes all the difference. lol. Thank you!
Now when I drag the formula over how can I make it so that net to office and close date columns don't shift with the formula, I tried putting $ in front and keep getting an error
Like this:
=SUMIFS(Table1[[Net to Office]:[Net to Office]],Table1[[Close Date]:[Close Date]],">="&CashFlow!C2,Table1[[Close Date]:[Close Date]],"<=&CashFlow!C3)
