Sumifs with Date Range
I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month.
Currently, I'm using
=SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start; <=DATE(2019; 01; 31); End:End; >=DATE(2019; 01; 31))
This will sum up all the FTEs in column FTE that correspond to Project A in January just fine. The problem is with months that are not fully covered, say a preoject only lasts until 15/02/2019. This will count the full february and thus suggest higher FTE usage than really required. Any way around this?
Best wishes, Alex
Help Article Resources
Check out the Formula Handbook template!